Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong?
Hi: I'm hoping to get some help re: my inconsistent (but always unsuccessful) attempts to create Mail Merge labels in MS Office 2010.
The labels I need to create require additional text surrounding the Merge Fields, ex.: Title: <<title>> or Reproduction source: <<column K>>. I assume this is possible because people must use Mail Merge to print envelopes with fixed return addresses, or things with the words "To:" and "From:," etc.
I've created a custom layout to match the non-standard-size labels I need to print and created an Excel file with the columns of text I need to import.
When I use Mail Merge wizard, one of the following problems occurs:
1) I cannot save a template of the labels I need with the built-in text included (I've tried opening both a template and a document of the label grid, then pasting the text onto the first cell so it'll get copied into the <<Next Record>> spaces.
2) Even though there are 6 labels/page, if Mail Merge does work, it'll import text into the first label of each page, NOT consecutively into each label.
3) Lastly, I'll get everything arranged and looking OK, then click "Preview results," and all the Merge Fields disappear and NO text is imported.
Hoping this question is laid out clearly enough. I'm at a complete loss for what I'm doing wrong, grateful for any help, suggestions, etc. anyone may have; please let me know if there's more information I can provide.
Thanks.
|