Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Whoknow Whoknow is offline
external usenet poster
 
Posts: 1
Default How do I mail merge 2 data source into one document?

Hello,

I have a document normal size (8 1/2 x 11 inches) that breaking into 2
parts. Both parts are the same with the last name and first name fields. I
would like to use the mail merge function in word to merge the data I have
(around 3000 names) into the document. The problem I have is Word treats
both parts as the same one and merge the same first, last name into both
parts of the document. How can I tell Word to merge first record into first
part of the document then goes on the merge the second record into the second
part of the document?

Thank you,
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How do I mail merge 2 data source into one document?

Insert a { NEXT } field (a Next record field) before the second (2nd)
part. That tells Word to move to the next record in the data source. If you
cannot find the right option to do that,
a. click in the Word document where you want to insert the field
b. press Ctrl-F9 to insert a pair of the special "field braces" { } (you
can't just type them)
c. type NEXT between them to give you
{ NEXT }


--
Peter Jamieson
http://tips.pjmsn.me.uk

"Whoknow" wrote in message
...
Hello,

I have a document normal size (8 1/2 x 11 inches) that breaking into 2
parts. Both parts are the same with the last name and first name fields.
I
would like to use the mail merge function in word to merge the data I have
(around 3000 names) into the document. The problem I have is Word treats
both parts as the same one and merge the same first, last name into both
parts of the document. How can I tell Word to merge first record into
first
part of the document then goes on the merge the second record into the
second
part of the document?

Thank you,


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
WANT TO REMOVE OLD SOURCE DATA FROM MAIL MERGE DOCUMENT Badri New Users 1 March 18th 07 06:34 AM
Can I add another data source to existing mail merge document? Lynne Schrupp Mailmerge 1 August 1st 06 06:02 PM
How do I create a data source fo mail merge using word document Shaaban Microsoft Word Help 2 May 9th 06 05:38 PM
printing a data source from a mail merge document Ann Mailmerge 1 August 3rd 05 04:48 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 08:20 AM.

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

About Us

"It's about Microsoft Word"