I can currently do everything with a simple mail merge aside from the file attachment. I look forward to seeing the results, and using this same technology to use a spreadsheet to "manage" data and images for card games I'm prototyping (I design board and card games in my spare time.).I'm trying to create an email mail merge that will personalize the emails to each individual on my list, at the same time attach a document. Now we have a mail merge document that's ready to accept data and crank out a bundle of pages with custom data and maps. If the spreadsheet has "Senate" for house_or_senate and "22" for house_or_senate_district_number, it'll look for "Senate22.jpg" It'll look for these images in the same directory that the Word document is in (which is the same directory that the Excel spreadsheet is in). What the above statement will do is put a picture in whose name matches what's in the "house_or_senate" cell in the spreadsheet, immediately followed by what's in the the house_or_senate_district_number cell, immediately followed by ".jpg". Ultimately, the placeholder in the Word document ended up looking like this: 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.
#USING MAIL MERGE WITH OUTLOOK AND EXCEL FOR MAC FULL#
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.
0 kommentar(er)
