Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
[email protected] jason@napavintners.com is offline
external usenet poster
 
Posts: 6
Default Advanced Word 2003 Mail Merge: Combining Records

Hey all:

I've created a merge based somewhat on these instructions:
http://cornell.veplan.net/article.aspx?&a=3815
that allows me to group similar records to display on one page.

For example: I have two tables: Registrants and Guests. Registrants
contains a list of companies and the main attendee, while Guests
contains additional people attending. These tables are linked through
an ID field and I'm able to display all the guests for a given company
on one page in my merge document. One problem... when a company has
more than two additional guests I get a line break before each
additional guest. Below is a snippit of what the code looks like. In
this example the records are grouped on Company.

------------------------------------
{IF {MERGESEQ} = 1"

" "" }{SET Donor1 {MERGEFIELD Company }}
{ IF {Donor1} {Donor2}"

{MERGEFIELD Company}

Dear {MERGEFIELD FirstName},

Here are your guests:
{MERGEFIELD Guest1}
{MERGEFIELD Guest2}" "{MERGEFIELD Guest2}" }{SET Donor2 {MERGEFIELD
Company} }
____________________

Here's the weird part... If I put any characters, line breaks or page
breaks after the last } each additional Guest2 will have a line break
before it. If I make it the last line on a page, the list of Guests
appears in one block.

Any thoughts???

 
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 to put graphics on envelopes? Steve Koenig Microsoft Word Help 21 April 29th 23 02:47 AM
Mailmerge directories not working Word 2003 Chris Mailmerge 5 January 16th 07 01:41 PM
how smart can a word 2003 mail merge letter be? Jesse Aufiero Mailmerge 6 November 30th 06 01:56 PM
Why can't I get Multiple instances of word? Laverne Microsoft Word Help 14 November 17th 06 01:35 PM
WP merge file to Word sstires Tables 4 February 14th 06 06:26 PM


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