mail merge

[penfold379]

can someone explain, or tell me where, in simple terms i can learn to use this. thanks

[Yorky Lass]

Open document to be mail merged .

Click Tools � Mail Merge � Form Letter

Click Create � Active Window

Click Get Data � Open Data Source

There will be no Excel spreadsheets showing � find MS Excel Worksheet on File types - currently showing All Word Documents

Click on the file you want to merge then click open

Click OK for Entire Spreadsheet

Click Edit Main Document

Place cursor exactly where you want to start and pick the font size you want to use.

Click Insert Merge Field (top left)

Click on the field you want (all the column headings on the spreadsheet appear)� move the cursor to the next starting place � click Insert Mail Field again and select the next entry. Continue with this until all sections are completed.

Click Tools - Mail Merge � Merge

Select what you want to merge i.e. All or just part of it

Click Merge

There you are done and dusted !!!!!

[penfold379]

thank you for your reply,
i want to use this to list addresses and print onto envelopes.
will what you have said do this or did i not explain myself properly, i am sorry if i didn't make myself clear

[wildwood]

If the above flies 'over your head' open your Word program and look for the help tab on top. Mail merge is a common function and is explained fully in all decent word processors.

[Yorky Lass]

I've never done envelopes but as they are on the same dropdown list as Form Letters I presume so, I've had a quick look and it does appear that the method is the same.

Sorry I can't be of more help.

[penfold379]

thanks all for your help i will try the suggestions, once again thanks

[penfold379]

sorry doesn't work. when i tried help it will only let me print and save one address i can't find a way to print a list of addresses save and then print onto envelopes later.

[Yorky Lass]

If you follow one line at a time of my instructions but substitute "Envelopes" for "Form Letter" you should be able to do it.
I've found this that may be of some help
http://www.hope.edu/resources/cit/tips/Word200 3Merge_Envelope.pdf

[YvonneM]

Are you using Word 2000 or 2003

[penfold379]

thanks, i think i have cracked it now.