#1
|
|||
|
|||
Mail merge with names in content
Hi,
I wasn't sure if I should post this in here, or in the Excel area as it involves both programs. I am sending out letters to groups of 10 people at a time, each of which is in an Excel spreadsheet with their name, address, company etc. What I want to do is not only do a mail merge for each person, but also mention the 9 other people in each of the letters. For example... First letter is addressed to person A. Within the letter it mentions the name of Person B, Person C, Person D etc... The second letter is addressed to person B. Within the letter it mentions the name of Person A, Person C, Person D etc... Is there a way for me to automate this process? Richard |
#2
|
||||
|
||||
Hi Richard,
In this case, you can employ a database field, where you: • use your Excel worksheet as the data source for the merge; and • insert a DATABASE field into the mailmerge main document to select the records for each individual’s letter. For example, if your workbook is called ‘c:\mywbs\teams.xlsx’ and the sheet is called Sheet1, the following nested field codes, which includes the database query, should result in a one-column table with the name of each participant in the group, other than the individual to whom the letter is addressed: {DATABASE \d "C:\\a\\mywbs\\teams.xlsx" \s "SELECT [firstname] & ' ' & [surname] FROM [Sheet1$] WHERE [ID] <> {MERGEFIELD ID}"} You can apply the DATABASE field formatting switches to get a suitable table format. Note 1: the above assumes your records have both a 'firstname' field and a 'surname' field. Note 2: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Saving INDV mail merges During the mail merge | sedain121 | Mail Merge | 2 | 10-04-2011 07:52 PM |
Selecting Names in New Mail Message | jackdashack | Outlook | 2 | 06-04-2011 04:19 PM |
Mail Merge help | dkwi04 | Mail Merge | 1 | 12-22-2009 11:23 PM |
Mail Merge | hiteshkataria | Mail Merge | 4 | 11-06-2009 05:11 AM |
Package for CD with links to Windows media player content and Flash Shockwave content | hectorh | PowerPoint | 4 | 10-15-2009 12:22 PM |