Hi there,



I am not sure whether this is possible, but I would like to create a Word mail merge template document. The idea is that individuals just need to open the document and have all the mail merge fields in place automatically and correctly formatted. Ideally, they should just have to press one macro button and the information from a set Excel spreadsheet would automatically pull across and populate the individual label cells.

I'm not sure whether there is any way to do this because the data list to pull the information across may change each time. Or should people just save it under the same name?

The label format I would like to select for the template is 'Herma 4201 - SuperPrint'. I would also like to include two mail merge fields, 'landline no.' and 'Ext no.' from the attached data list. I would also like the word 'Ext:' to appear before the ext no. on the label. The two fields should be formatted in bold in Calibri (body) 12 and centred in each cell.

Label example:
01539751504 (landline no.)
Ext. 301 (extension no.)

Ideally, I would like to be able to use the same mail merge template for multiple data lists without the need to reformat all the labels each time.

Would anyone know whether this is possible?

Many thanks,

Daniel

Attached Files

TEST data list.xlsm (16.7 KB, 8 views)

What you ask is quite straightforward. Just create the merge document. Attach the worksheet to the document. Insert the fields where you want them along with any fixed text, then save the document. See Mailmerge with Word 2007/2010

If you keep the same filename for the worksheet each time there is no need to change anything. If not you will have to attach the required worksheet each time.

You will cause fewer problems for yourself if you have the data starting at cell A1, rather than randomly placed in the middle of the sheet.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Hi gmayor,

Thank you very much for your reply. I have got it working now!!!

Daniel