Microsoft Office Forums Microsoft Word Catalogue/Directory Mailmerge Tutorial

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 04-08-2018, 05:02 PM
macropod's Avatar
macropod macropod is offline Microsoft Word Catalogue/Directory Mailmerge Tutorial Windows 7 64bit Microsoft Word Catalogue/Directory Mailmerge Tutorial Office 2010 32bit
Administrator
Microsoft Word Catalogue/Directory Mailmerge Tutorial
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default Microsoft Word Catalogue/Directory Mailmerge Tutorial

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:
https://support.microsoft.com/en-us/...tegory-in-word
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
Attached Files
File Type: zip Catalogue Mailmerge.zip (85.5 KB, 131 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Word Field Maths Tutorial macropod Word 0 04-08-2018 04:58 PM
Microsoft Word Date Calculation Tutorial 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
Pictorial directory using mailmerge JohnFinNC Mail Merge 6 10-04-2012 06:36 PM
Directory Mailmerge rohitjain80 Mail Merge 1 02-12-2012 03:42 AM


All times are GMT -7. The time now is 05:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft