Donate SIGN UP

mail merge

Avatar Image
penfold379 | 16:41 Thu 01st Mar 2007 | Computers
9 Answers
can someone explain, or tell me where, in simple terms i can learn to use this. thanks
Gravatar

Answers

1 to 9 of 9rss feed

Best Answer

No best answer has yet been selected by penfold379. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
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 !!!!!
Question Author
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
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.
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.
Question Author
thanks all for your help i will try the suggestions, once again thanks
Question Author
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.
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
Are you using Word 2000 or 2003
Question Author
thanks, i think i have cracked it now.

1 to 9 of 9rss feed

Do you know the answer?

mail merge

Answer Question >>