WORD 2002 Mail Merge w/ Excel data

[patkung]

We are having real problems setting up a mail merge with Word 2002. We finally got it set up and now find we can't print it except by doing it one page at a time. Can't even do a print preview and see all the pages at once.

I have secretaries that have used mail merge since the DOS version, that find this totally UNFRIENDLY.

We did not use the Wizard because that was very unfriendly. I put the merge toolbar on and chose the Data Source, added the Merge Fields tool to the bar, and added the fields. We then did a Merge to New Document and saved it. When we brought it open we could not preview all the pages, nor could we print all the pages at once. We had to do it one page at a time.

Any one know how to make it allow us to print all at once.

Thanks for any help.

 

[amandarose80]

I have step by step instructions on how to use the mail merge wizard in Word 2002. If you would like them e-mail me at amccammack@vlcpa.com.
I would be glad to share them with you. It has helped the secretaries in my office a lot.
I will completely agree with you, this version isn't as user friendly as past versions.

 

[tav1035]

amandarose80,
can you post them?
2002 ?@#%! at mail merge.
tav

 

[amandarose80]

1. Select Tools, Letters and Mailings, Mail Merge Wizard…
2. Select the document type to the right, i.e. letter or labels. (If you are using a letter that you have created and you have opened the mail merge wizard from that letter, you will want to select, “Use the current document”.)
3. Click Next
4. Select Label Options. Be sure that the label type is correct. (Usually 5160)
5. Click Next
6. Select Use an Existing List.
7. Click Browse and select the list you are using (Excel Spreadsheet).
8. Select the sheet containing the list you want to use.
9. View the list you have selected. You may uncheck any recipients that you do not wish to include. Then click OK.
10. Click Next
11. Click More Items…
12. Select then click Insert for each field you would like to include. Click Close when you are finished inserting fields.
13. Arrange the fields including spaces, returns, and commas, if needed. (If you are creating labels, click Update All Labels.
14. Click Next
15. If the setup is the way you would like it, click Next. If not, click Previous to make changes.
16. Click Edit Individual ______...
17. Make any needed changes. Save you would like to. Then print.