Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Lynne Schrupp Lynne Schrupp is offline
external usenet poster
 
Posts: 1
Default Can I add another data source to existing mail merge document?

I've already created a mail merge doc but now I have another excel file I
want to add to that mail merge. How can this be done?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Can I add another data source to existing mail merge document?

The mail merge main document can only be attached to one data source at a
time, but as long as the names of the fields in the data source match those
in the mail merge main document, you can change the data source from one
Excel file to another.

In Word 2000 and before, you just go to step 2 of the mail merge helper and
click on Open Data file and select the new file.

If you are using XP and later, I suggest that you select Toolbars from the
View menu and then check the Mail Merge item to display the mail merge
toolbar. You can then use the second button from the left hand end of the
toolbar to attach the data source to the main document.

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

"Lynne Schrupp" Lynne wrote in message
...
I've already created a mail merge doc but now I have another excel file I
want to add to that mail merge. How can this be done?



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 change a mail merge to a new document ADJS Mailmerge 4 April 20th 06 04:02 PM
Mail Merge with separate Source Header document Singlej Mailmerge 2 March 29th 06 02:19 PM
How Come? Michael Koerner Mailmerge 9 February 10th 06 10:29 PM
Word 2002 cannot find its Excel data source for mail merge harryedwards Mailmerge 5 November 23rd 05 11:09 AM
How do I print a mail merge data source without the main document Lynn A Mailmerge 0 January 21st 05 10:39 AM


All times are GMT +1. The time now is 02:13 AM.

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"