This entry was posted in Life by Rich Brown. Let me know in the comments if you find find out more.I could not find documentation about what the \* MERGEFORMAT string does.I think the \d option of the INCLUDEPICTURE command causes Word not to save the images in the document, making the source file considerably smaller.It’s easiest if the images are all the same size, to minimize resizing effort.If you type Alt-F9 (Option-Fn-F9 on Mac), the «variables» in the document turn into their underlying representation: «Field1» turns into in a document.Click Preview Results again to un-preview results and continue editing the document.When you click the Preview Results button (in the Ribbon), you’ll see your mail merge results, with substitutions of the live data for your «variables» Click “Insert Merge Field” in the Ribbon and select your fields.Click Select Recipients – you’ll need to choose the Excel document (and proper tab) that has the data to be merged.Click Start Mail Merge and choose Letters.If you’re retrieving images from a website, you’ll need a field with the links. The Excel document should have headers in the first row that describe the data.Create an Excel spreadsheet with links (URLs) to the desired images.Once I had images inserted into the document, I needed to figure out how to adjust their size.You need to use (poorly-documented) keyboard commands to type the commands.Word uses voodoo magic to accomplish this. ![]() ![]() I think I described everything, but please let me know in the comments if I’ve missed something. I’m not claiming this is the only way/best way, just that it worked for me. I wrote this note so that the next time I need to revise the document (and stumble over this process), I’ll have these notes. That said, I needed to use it for a project to create a document that plucks up variables from a spreadsheet and drops them into a pretty template for each page. The tutor uses an Access database as the data source and explai. What a crock! How badly documented can a facility be? There are lots of tutorials on the basics of Microsoft Mail Merge, but there is a dearth of information for the INCLUDEPICTURE facility to include images, especially if the images are retrieved from a link/url. This video demonstrates how to use mail merge to merge photos into a Microsoft Word document.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |