![]() |
#1
|
||||
|
||||
![]() Attached is a tutorial on how to use Word's mailmerge facility to create lists sorted by category. Microsoft has similar articles at: https://support.microsoft.com/en-au/...y-in-word-2000 and: Use mail merge for bulk email, letters, labels, and envelopes - Office Support but my tutorial goes way beyond those articles' scope by: a ) providing a sample data source that can be used to demonstrate/test the use of different keys, b ) including working mailmerge fields c ) adding examples to show how: • text can be categorised using two keys • text can be added after the repeated data • group and sub-group counts and totals can be calculated without the need for such fields in the source data • to create a two-column output • to create a series of tables from the merged data • to shade alternate rows when merging to a table • to merge to email Plus, unlike the field coding suggested by the MSKB articles, my approach doesn't insert extra lines for Excel data sources. Note: Please read the tutorial before trying to use the mailmerge main document for a mailmerge - the merge field coding you'll need is in the tutorial and has to be copied from there into the mailmerge main document before you can do a mailmerge. Enjoy
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
macropod | Word | 0 | 04-08-2018 04:58 PM |
![]() |
macropod | Word | 0 | 04-08-2018 04:57 PM |
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge | Berryblue | Mail Merge | 1 | 11-13-2014 05:36 PM |
![]() |
JohnFinNC | Mail Merge | 6 | 10-04-2012 06:36 PM |
![]() |
rohitjain80 | Mail Merge | 1 | 02-12-2012 03:42 AM |