#1
|
|||
|
|||
How to Save & Reuse a Word 2007 Mail Merge Template
I use Word2007 mail merge only once a year, for holiday envelopes. So I'm unfamiliar with most of the options. My recipients are stored in Excel. I have saved a (single envelope) .docx with my return address and «FirstName» «LastName» «Address», etc. for recipient. But I don't know how to use it. Every year I have to start from scratch. Thankfully, I've made a checklist so that I don't have to learn everything anew each December.
It just makes sense to use the saved layout instead of redoing the whole process each time. Where & how in the "Start Mail Merge/Envelopes/Select Recipients . . ." sequence do I tell it to use the saved layout (template)? Is a .docx the correct file type? |
#2
|
||||
|
||||
Once you've done the mailmerge main document setup, simply save it as a document (not a template). Having done that, it will be ready and waiting next time you want to do a merge - simply answer 'yes' to the prompt Word will give you when you open the document, then click 'Finish and Merge'. Done.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks, Paul, for your reply, but I don't understand.
I have a (one page empty) file with the basic layout of the envelopes. I saved this file 2-3 years ago, so I'm not sure at what point in the process that I created it. I assume this is the 'main document' to which you refer. There are no Word prompts when I open it & 'Finish & Merge' is grayed out. Obviously, as is, mine isn't a complicated task, but even simpler would be better. My Name 123 Main Street Mytown, Mystate 12345 «FirstName» «LastName» «Address1» «Address2» «City», «State» «Zip» I always save the latest populated document which I print later, usually only a small number of envelopes at a time. I apologize for being so dense. |
#4
|
||||
|
||||
Quote:
• re-opened the document and answered 'no' to the prompt before re-saving the document; or • changed the document type from a mailmerge main document to a normal document (which you can do via the mailmerge tools. To remedy the situation, simply use the 'select recipients' mailmerge tool to reconnect the document to your Excel workbook. You should then be able to complete the merge via the 'Finish & Merge' button. Do remember to save the updated mailmerge main document. Whether you save the latest populated document to print later is up to you; it isn't necessary, as you can run the merge when you're ready to print and you can even merge direct to the printer if you want.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Quote:
I saved the populated file as a "regular" (.docx) file for later printing so I can review & "edit individual documents" as needed. |
#6
|
||||
|
||||
You should not have saved the mailmerge main document as a template (dotx), but as a document (docx). Saving it as a template means Word will create a new, redundant, mailmerge main document every time you click on the template to run a mailmerge and is liable to result in you getting the same SQL prompt to answer, twice.
Yes, you should answer 'yes' to the SQL prompt. By saving the document created from the template, you now have both a template and a mailmerge main document. You can delete the template - you don't need it. When you open the mailmerge main document, you will need to answer 'yes' to the SQL prompt before you can use 'Finish & merge' - which is the pre-requisite to 'edit individual documents'.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Thanks, Paul. I would mark this solved, but I don't know how.
|
#8
|
||||
|
||||
Done. You may not be able to until your post count increases.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
mail merge help, template, word 2007 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I automate the mail merge process in word for making labels using the 5160 Avery template? | zrobles | Mail Merge | 5 | 08-07-2015 02:07 AM |
Word Mail Merge Template | newbie406 | Mail Merge | 2 | 02-20-2015 08:08 AM |
Word Mail Merge File Save | mickeyw3340 | Mail Merge | 2 | 12-18-2012 11:30 AM |
Excel 2007 to Word 2007 Labels mail merge not working | rec | Mail Merge | 0 | 07-31-2010 10:45 AM |
Outlook Template for Word Mail Merge | jhweaver | Mail Merge | 0 | 01-17-2007 06:06 AM |