Using VBA for Mail Merging

vbaformailmerge · #1 06-03-2019, 05:10 AM

Quote:

Originally Posted by macropod

Without actually seeing the problem mailmerge main document and some sample data, its impossible to diagnose the issue. Can you attach the document & sample data to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

Oh, I'm so sorry - of course ill link it for you.

So for example, I will be using the main doc and the database for merging so my fake database contains 30 records which I would like to merge and save as pdf for every 5 records together in one document.

So I should end up with 6 pdfs in total with 5 records each. If that makes sense! I was playing around with a macro but I turned on the comp today and its vanished!

any idea why it disappeared? Thank you so much!

macropod · #2 06-03-2019, 05:20 AM

Your mailmerge main document is trying to link to a CSV file, not to your Excel file.

There is also no VBA code in your mailmerge main document.

Hardly surprising, therefore, that it doesn't 'work'.

Quote:

Originally Posted by vbaformailmerge

I was playing around with a macro but I turned on the comp today and its vanished!

any idea why it disappeared?

Evidently, you've either deleted the macro or it was never in the document - perhaps it was in a Word template that you closed without saving changes.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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