Using VBA for Mail Merging

macropod · #1 05-30-2019, 04:54 PM

See Send Mailmerge Output to Individual Files in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
The code there outputs every record as a separate file. It could be adapted, though, to group records if that's what you really want.

PS: When posting code, please use the code tags, indicated by the # button on the posting menu. Without them, your code loses much of whatever structure it had.

vbaformailmerge · #2 05-31-2019, 01:02 AM

Quote:

Originally Posted by macropod

See Send Mailmerge Output to Individual Files in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
The code there outputs every record as a separate file. It could be adapted, though, to group records if that's what you really want.

PS: When posting code, please use the code tags, indicated by the # button on the posting menu. Without them, your code loses much of whatever structure it had.

I tried using this code but nothing happens? I changed the folder name and made sure it was set to .doc too. Can't seem to figure out why it is not working

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
0 showing in address when mail merging	Shazz	Mail Merge	2	03-11-2016 01:54 AM
Merging, but not with mail	ksims3	Word	1	07-29-2014 08:27 PM
How would you go about mail merging this set of data	willsonfang	Mail Merge	1	09-29-2013 07:16 PM
Gaps in address mail merging	Trixz_D	Mail Merge	2	08-05-2012 04:23 AM
Mail Merging more than 1 line of data ??	Keith24249	Mail Merge	0	10-16-2009 06:36 AM