Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-10-2018, 01:48 AM
plupton plupton is offline Send Mailmerge Output to Individual Files - Help with VBA Windows 10 Send Mailmerge Output to Individual Files - Help with VBA Office 2016
Novice
Send Mailmerge Output to Individual Files - Help with VBA
 
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, 22 views)

Last edited by plupton; 01-10-2018 at 03:32 AM. Reason: Added 2nd issue
Reply With Quote
  #2  
Old 01-10-2018, 10:22 PM
plupton plupton is offline Send Mailmerge Output to Individual Files - Help with VBA Windows 10 Send Mailmerge Output to Individual Files - Help with VBA Office 2016
Novice
Send Mailmerge Output to Individual Files - Help with VBA
 
Join Date: Jan 2018
Posts: 2
plupton is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 12-24-2019, 07:18 AM
simplyez4u simplyez4u is offline Send Mailmerge Output to Individual Files - Help with VBA Windows 10 Send Mailmerge Output to Individual Files - Help with VBA Office 2019
Novice
 
Join Date: Dec 2019
Posts: 5
simplyez4u is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send Mailmerge Output to Individual Files - Help with VBA 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 - Help with VBA Send Mailmerge Output to Individual Files - troubleshooting help mxk372 Mail Merge 1 07-06-2017 03:49 PM
Send Mailmerge Output to Individual Files - Help with VBA Mailmerge Directory - Incomplete Data Appearing in Merge Output Gwinnett Mail Merge 5 03-05-2017 02:24 PM
Send Mailmerge Output to Individual Files - Help with VBA Send Emails from MailMerge in Word using Specified Email Address Baldeagle Mail Merge 6 07-25-2015 05:32 AM
Send Mailmerge Output to Individual Files - Help with VBA Mailmerge Individual Documents DaddyMac Mail Merge 4 06-06-2013 09:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:51 PM.


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