Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-05-2017, 02:31 PM
macropod's Avatar
macropod macropod is offline Mail Merge Next Record If rule Windows 7 64bit Mail Merge Next Record If rule Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

As described in the tutorial, you need to create two separate documents:
1. An e-mail mailmerge main document, which you configure for a normal e-mail merge. This file should contain whatever text you need and a single ĞDatağ mergefield for the data. Save this document in an appropriate folder with the name ‘Email Merge Main Document.doc’. Your mailmerge main document is not set up like that; neither is it named appropriately.
2. A separate Catalog/Directory mailmerge main document, with a single paragraph containing field coding as described in the tutorial. You should add the macros from the tutorial to this document*, then save it in the same folder as the ‘Email Merge Main Document’. You can give this document whatever name you want except for:
• ‘Email Merge Main Document.doc’; and
• ‘EmailDataSource.doc’
Once you’ve done that, run the ‘RunMerge’ macro.

When you run the the ‘RunMerge’ macro, it will create a document named ‘EmailDataSource.doc’. You can delete this file after the merge has finished if you don't need it for anything else.

* You need all three macros from that part of the tutorial. The ‘EmailMergeTableMaker’ macro is called by the ‘RunMerge’ macro; without it the ‘RunMerge’ macro will fail. Similarly, the ‘TableJoiner’ macro is called by the ‘EmailMergeTableMaker’ macro; without it the ‘EmailMergeTableMaker’ macro will fail
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 03-07-2017, 08:05 AM
RHensley RHensley is offline Mail Merge Next Record If rule Windows 8 Mail Merge Next Record If rule Office 2013
Novice
Mail Merge Next Record If rule
 
Join Date: Feb 2017
Location: Baltimore, MD
Posts: 10
RHensley is on a distinguished road
Default Maill Merge Next Record If

Thanks Paul we will try it out. Thanks again for the thorough explanation.
Reply With Quote
Reply

Tags
mail merge, next record if



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Next Record If rule Mail Merge Repeat Record a certain number of times stacey_e Mail Merge 7 07-07-2023 01:27 AM
Mail Merge Next Record If rule mail merge skips 16th record only - of 23 total. passenger Mail Merge 1 07-24-2012 04:03 PM
Mail Merge Next Record If rule Mail merge to print each record as it is created PNGento Mail Merge 1 01-26-2012 02:00 PM
avoid duplicete record and merge the record with the existed record hemant.behere Excel 0 01-10-2012 02:53 AM
Extraneous record in Word Mail Merge aldo13 Mail Merge 0 01-23-2006 01:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:18 PM.


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