Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

LinkBack Thread Tools Display Modes
Old 01-10-2018, 01:48 AM
plupton plupton is offline Windows 10 Office 2016
Join Date: Jan 2018
Posts: 2
plupton is on a distinguished road
Smile Send Mailmerge Output to Individual Files - Help with VBA

Hi, The post on MailMerge Tips and Tricks is really helpful and especially the Macro to send Merge output to Separate Files.
My application is to create invoices (separate pdf docs) from a master Excel file as the data source. I have got it to work fine where data source and main doc are in the same folder.

Would really appreciate some help with 2 issues:
1. It is better if the data source is in a separate folder - but with main doc and outputs in the same folder.
Need some help to amend code to accomodate this.

2. As the data source is a master file, I only want to merge selected records. Am using the 'Edit Recipient List' function to select only the required records. Also changed the macro name to MailMergeToDoc so can just click on 'Finish & Merge>Edit Individual Documents'. This works a treat and the merge docs are created fine, but the process ends with the attached error message

This happens at the .ActiveRecord = i line
Fine to just click the 'OK' button and continue, but would be nice to have a Message like 'Docs for your selected records are done' .

I am very new to VBA and have fiddled around without success. I would really appreciate some help with the code.

Thanks, Peter
Attached Images
File Type: jpg Merge Data Source Error.JPG (16.2 KB, 10 views)

Last edited by plupton; 01-10-2018 at 03:32 AM. Reason: Added 2nd issue
Reply With Quote
Old 01-10-2018, 10:22 PM
plupton plupton is offline Windows 10 Office 2016
Join Date: Jan 2018
Posts: 2
plupton is on a distinguished road

From other posts, it seems better and more practical to always have main doc and data source in the same folder.
I solved the problem by putting them in the same folder - but sending the output to a different folder.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Save mailmerge records as individual word files using VBA beefcake2000 Word VBA 3 11-10-2017 09:55 PM
Send Mailmerge Output to Individual Files - troubleshooting help mxk372 Mail Merge 1 07-06-2017 03:49 PM
Mailmerge Directory - Incomplete Data Appearing in Merge Output Gwinnett Mail Merge 5 03-05-2017 02:24 PM
Send Emails from MailMerge in Word using Specified Email Address Baldeagle Mail Merge 6 07-25-2015 05:32 AM
Mailmerge Individual Documents DaddyMac Mail Merge 4 06-06-2013 09:22 PM

All times are GMT -7. The time now is 07:12 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft