Reply
 
Thread Tools Display Modes
  #1   Report Post  
 
Posts: n/a
Default Include Cc: details on merged letters using mail merge database or fields? (not email Cc:)

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.

  #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.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I include an attachment to mail merged email? Kathy Mailmerge 4 September 6th 05 12:45 PM
How to change details in specific records on a mail merged Letter Kushum Microsoft Word Help 9 August 31st 05 04:32 PM
Query a mail merge for multiple letters at once? Brese Mailmerge 1 May 20th 05 02:10 PM
Printing mail merged letters on headed and plain paper Paul Mailmerge 1 April 26th 05 11:04 PM
Page numbering on a mail merged document Bevan Mailmerge 1 March 10th 05 03:57 AM


All times are GMT +1. The time now is 11:32 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"