Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
TFFAV TFFAV is offline
external usenet poster
 
Posts: 1
Default Combine Mail Merge records when different records have 1 common fi

How to combine separate records that have common data in one filed into one
letter. Example: Two separate records that have the same data in an
"address 1" field but different data in a "dollar amount" field. The merged
letter would have the "address 1" appear once (combined) at the top of the
letter with the "dollar amount" data from both records appearing somewhere in
the body of the letter stacked one on top of the other. This one letter
would replace the need for two separate merged letters to the same "address
1".
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Combine Mail Merge records when different records have 1 common fi

Word merge isn't designed to do this "one-to-many" type of merge. If
possible, use something that is, such as Access reports. But if you need to
use Word, you may find the following articles useful:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

http://support.microsoft.com/default...b;en-us;211303

http://www.knowhow.com/Guides/Compou...poundMerge.htm

Peter Jamieson

"TFFAV" wrote in message
...
How to combine separate records that have common data in one filed into
one
letter. Example: Two separate records that have the same data in an
"address 1" field but different data in a "dollar amount" field. The
merged
letter would have the "address 1" appear once (combined) at the top of the
letter with the "dollar amount" data from both records appearing somewhere
in
the body of the letter stacked one on top of the other. This one letter
would replace the need for two separate merged letters to the same
"address
1".



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
mail merge with word 2003 ken sunshine New Users 5 March 23rd 06 05:01 PM
mail merge with non-unique records tjb Mailmerge 3 December 13th 05 05:30 AM
Mutliple Records for each document in mail merge Trey Mailmerge 1 September 7th 05 04:51 AM
Saving Mail Merge Records & also printing them. Glenn Mailmerge 4 September 2nd 05 02:12 PM
How to Mail merge records into a new/separate document Denise Mailmerge 1 February 1st 05 11:25 PM


All times are GMT +1. The time now is 07:12 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"