#1
|
|||
|
|||
Word Mail Merge Template
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Hi gmayor,
Thank you very much for your reply. I have got it working now!!! Daniel |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Template Not Recognizing Data | Ncaljets | Mail Merge | 1 | 11-02-2014 10:37 PM |
Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? | brunofirst | Mail Merge | 7 | 02-27-2014 02:30 PM |
Creating new documents from a mail merge template | pnjcarter | Mail Merge | 1 | 02-03-2014 06:42 PM |
Mail merge into a template | born | Mail Merge | 1 | 09-13-2011 01:42 AM |
Outlook Template for Word Mail Merge | jhweaver | Mail Merge | 0 | 01-17-2007 06:06 AM |