Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-02-2020, 06:34 AM
alexandersmit alexandersmit is offline Send Mailmerge Output to Individual Files from tips & tricks not working Windows 10 Send Mailmerge Output to Individual Files from tips & tricks not working Office 2019
Novice
Send Mailmerge Output to Individual Files from tips & tricks not working
 
Join Date: Nov 2020
Posts: 1
alexandersmit is on a distinguished road
Default Send Mailmerge Output to Individual Files from tips & tricks not working

Good afternoon,

I want to use the macro Send Mailmerge Output to Individual Files from the Sticky: Mailmerge Tips & Tricks . However, when I execute it doesn't do anything.

Some things I tried:


- Check if first_name and last_name are indeed filled in as they are used for filename handling,
- Change name to MailMergeToDoc as suggested in the tips & tricks to intercept Edit individual documents
- Uncomment 'StrFolder = .DataFields("Folder") & ""
- Dubble, triple, quadruple check if file is saved at a location which is accesible

However none work, and I'm out of ideas. Anyone got it to work?

Thanks!
Alexander
Reply With Quote
  #2  
Old 11-02-2020, 07:40 AM
gmayor's Avatar
gmayor gmayor is offline Send Mailmerge Output to Individual Files from tips & tricks not working Windows 10 Send Mailmerge Output to Individual Files from tips & tricks not working Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Paul will no doubt be along shortly, but you might consider https://www.gmayor.com/individual_merge_letters.htm.
or
 https://www.gmayor.com/MergeAndSplit.htm
or
E-Mail Merge Add-in
all of which will split mailmerge to separate files, using a variety of processes.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 11-02-2020, 02:48 PM
macropod's Avatar
macropod macropod is offline Send Mailmerge Output to Individual Files from tips & tricks not working Windows 10 Send Mailmerge Output to Individual Files from tips & tricks not working Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

If it's not working, the most likely explanation is that you're not running it against a mailmerge main document...

And yes, it does work.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send Mailmerge Output to Individual Files from tips & tricks not working Send Mailmerge Output to Individual Files - Help with VBA plupton Mail Merge 2 12-24-2019 07:18 AM
Send Mailmerge Output to Individual Files from tips & tricks not working Sending Mailmerge Output to Individual Files QCaesar Mail Merge 4 07-26-2019 03:33 PM
Send Mailmerge Output to Individual Files from tips & tricks not working Send Mailmerge Output to Individual Files - Help Needed sunrise06 Mail Merge 4 12-22-2018 07:56 PM
Send Mailmerge Output to Individual Files from tips & tricks not working Send Mailmerge Output to Individual Files - troubleshooting help mxk372 Mail Merge 1 07-06-2017 03:49 PM
Send Mailmerge Output to Individual Files from tips & tricks not working Mailmerge Tips & Tricks macropod Mail Merge 0 07-09-2014 12:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:08 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