#1
|
|||
|
|||
Help merging with consistent categories
Hello,
I am pretty much a newbie when it comes to Mail Merge. I can do the basics but then I get brain ache. I have attached examples of what I would like to be able to do. I would like the categories that are in the excel sheet going across "C1 - C6" to be consistent with each document. However, these can change / be updated as time goes on. I would like to be able to do so without having to type in the categories into the word document. I can get it to return the marks specific for a person but I have to type in the category manually. Help please. Hope it makes sense! |
#2
|
||||
|
||||
The problem you'll have with doing what you've described is that Word uses the data in the first row in the Excel data source for the mergefield names to be used for all rows in that column. Accordingly, if you change the category names in Excel, the mailmerge won't recognize the data.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Spaces between words in Office 2010 not consistent | Zjef | Word | 1 | 10-21-2014 03:52 PM |
Line alignment not being consistent | elishafreedman | Word | 5 | 01-23-2014 06:18 AM |
Consistent Text Positioning when Using 'Fields' | HangMan | Mail Merge | 1 | 12-10-2013 06:43 PM |
How to force tabs to be consistent | PatrickYork | Word | 1 | 05-01-2012 07:21 AM |
Form submenu not consistent! | talkinglens | Word | 5 | 12-18-2010 02:31 PM |