#1
|
|||
|
|||
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 Last edited by plupton; 01-10-2018 at 03:32 AM. Reason: Added 2nd issue |
#2
|
|||
|
|||
Hi,
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. |
#3
|
|||
|
|||
How did you amend the code to save the merged docs into a separate folder? Also, is there a way to set not to show any merged docs? It always display merged docs and I have to close all letters afterward one by one.
|
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 |