View Single Post
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

To do this, you would need to have your data source arranged as follows
(shown here in column format where the first column contains field headings
and the second column a typical row of data

Name Joe Bloggs
OtherFields
CC1 Jane Clinton
CC2 William Gates
CC3 Steve Jobs
CC4 John Bush

Then in your mailmerge main letter, you would have mergefields as follows:

Dear Name


Blah, blha, blah, blah


Yours sincerely


Sharon Donnelly
Cc: CC1, CC2, CC3, CC4,...

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
wrote in message
oups.com...
I wonder if anyone can offer any advice to what must be something
really stupid that I'm doing wrong. I'm totally puzzled by what I just
assumed would be a breeze:


To explain, I've used Word 2003 to write a letter which is to be sent
to eight people. I've set up the mail merge using the wizard. From this
the data (names and addresses of all eight recipients) are saved within
the MS Access file it created. I've followed through the wizard and the
mail megre works great - except ...


At the bottom of each merged letter I need to show the names of the
other seven recipients to which the letter was sent. I thought, I'll do
Cc: then pull the names from the mail merge database:


________________________________________


Dear Joe Bloggs


Blah, blha, blah, blah


Yours sincerely


Sharon Donnelly
Cc: Jane Clinton, William Gates, Steve Jobs, John Bush, ....
________________________________________


I've tried every permutation that I can think of and have had no joy.
Everyone I have asked today thought it would be easy too, but failed
when they tried. One of my colleagues suggested writing a macro or some
VBA code - way beyond me. Surely something as advanced as Microsoft
Word must have this little feature tucked away somewhere?


Any advice would be much appreciated. Thanks in advance.

Shaz

P.S. I posted this in another group a few moments ago but see that this
group seems to be more active. Apolgies for cross posting.