VBA mail merge labels

d31b0y

New Member
Joined
Sep 22, 2014
Messages
2
Hi all,

I am trying to setup a mail merge from an excel document to a word template. The template is already setup with the fields but I just can't seem to get it to work.

I have tried lots of different snippets of code but haven't been able to get any of them to work for me. I'm hoping it's straight forward but I just can't work it out.

I've attached sample data source and the template. I'd really appreciate it if someone could take a look.
https://www.dropbox.com/s/io4vm0v3we2fswl/macro.zip?dl=0
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Rockhopper3

Board Regular
Joined
Apr 11, 2006
Messages
131
Hi D31b0y,
What version of Word and Excel are you using? If you are using the ones from Office 2010, Word has a mail merge tab that puts everything in for you. From the ribbon in Word, click on Mailings, then click on Start Mail Merge and select the type you want to do. Then click Select recipients and Use from am existing list. Find the excel file where your data is saved. Then click on Edit recipients list and select the people you want to include in the list. Then all you need to do is link the correct columns to you mail merge fields. You do this by click on Match Fields (small button in the ribbon in the Write & Insert Fields section of the Mailings Tab). Select the appropriate columns for the appropriate fields (i.e. Name = A1, Street = A2, etc.). Hope this helps. I believe some of the older versions of Office have a similar sort of setup, but it may not be as straight forward.

Cheers.

Rockhopper
 

Watch MrExcel Video

Forum statistics

Threads
1,109,330
Messages
5,528,043
Members
409,799
Latest member
mlewan_ca

This Week's Hot Topics

Top