Mail Merge with Multi values.

[fb0gris1091]

I have a letter mail merge that works very well with one record (order
details) per customer, but I would like to have many orders lines, dependent
on the data. The example below, the letter for customer 1 would only show 1
order, then the letter for customer 2, 2, and customer 3, 1, and customer 4,
there would be 3 order lines.

The data source is an access database.

Eg. Customer Order Number
1 1312
2 3232
2 4352
3 532
4 6432
4 6423
4 7234

Any assistance in this would greatly be appreciated.

Thanks.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi fb0gris1091,

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Badger]

Hi fb0gris1091,

If you're still stuck, have a look at Microsoft QB211303or Q294686.
It gives examples with explanations.
If you're still stuck, mail me and I'll sort some sample documents for you.

Regards
Paul


"Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS"

 

[wally]

I just did this and it works great. However, the new documents do not have a great naming convention. Is there a way to have the macro use selective text to use as the name (ie. text after the 3rd carriage return until the 4th carriage return)?d

----- Doug Robbins - Word MVP - DELETE UPPERCA wrote: ----

Hi fb0gris1091

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.ht

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis
Hope this help
Doug Robbins - Word MV