Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2011, 04:32 PM
richard82 richard82 is offline Mail merge with names in content Windows XP Mail merge with names in content Office 2000
Novice
Mail merge with names in content
 
Join Date: Jul 2011
Posts: 1
richard82 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-07-2011, 11:28 PM
macropod's Avatar
macropod macropod is online now Mail merge with names in content Windows 7 64bit Mail merge with names in content Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge with names in content Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Mail merge with names in content 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft