how to do a mail merge in word and excel 2007

I had to drag and drop them in from the Mail Merge Manager tray of placeholders. I learned that I could not type mail merge field identifiers into the INCLUDEIMAGE path and have it recognize them.I realized I completely ignored pressing Control+F9 to enter editing mode.I also found a link to the following video:

I also tried inserting a Field (see picture to the right) then hand-editing it to include MERGEFIELD data with no success. I tried to type field definitions in by hand and it wasn't working. I completely overlooked that important tip. What this means is that you have press Control+F9 (or Alt+F9, depending on your computer) to shift Word into 'field creation and editing mode.' This lets you type in field definitions by hand.

If you read that page very carefuly, you'll spot that it says you have to use Control+F9 to 'place the field boundaries' by hand. You can use mail merge fields ('MERGEFIELDS') in an INCLUDEIMAGE field to dynamically change the name of the image it's inserting.You can put an 'INCLUDEIMAGE' field in a Word document to have it include an image that's not in the Word document itself.So: How can we tell Word to import specific images? To find the answer, I Googled, 'mail merge images word 2010' and found the following link: When Word imports information from an Excel spreadsheet during a mail merge, it only wants text-based data. You can't put an image in an Excel spreadsheet cell and import that image into a mail-merged Word document. Each district has a custom map of resources. Y'see, our reports don't just have text-based data. Easy-peasy, right?Īh! But there's a complication (Isn't there always?). You create a spreadsheet with all the data you want to include in each report, you create a Word document with embedded mail merge fields from the spreadsheet, then you run the mail merge and it automagically creates all the documents (or district reports in our case) you need. If you're familiar with Mail Merge in Microsoft Word and Excel, this is a relatively easy task. For example, if you're the Texas Senator for district 22, we want to give you a page full of information about district 22. We want to take that data and print a custom one-page report of Veteran population and services for each Texas representative's district, specific to that rep's district. We have up-to-date data for Veteran population and services for every House and Senate district in Texas. If you want to learn something technical, read on! This is about how I learned to use Mail Merge in Microsoft Word to embed a unique image for each mail merged entity. If you're looking for Vet-related stuff, you'll likely prefer to read something else. A heads-up: This doesn't really pertain to Veterans.

How to do a mail merge in word and excel 2007