VBA mail merge labels

[d31b0y]

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

 

[d31b0y]

Oh no... 30 pages down after 2 days. Should I give up hope?

 

[Rockhopper3]

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