Donate SIGN UP

Mail merging - Excel and Word

Avatar Image
spaced | 11:12 Thu 14th Sep 2006 | Technology
2 Answers
Does anyone know where I can download a idiots guide or view an idiots guide online showing how to mail merge in excel and word?

I need to find something that explain how you do mail merging in lay mans terms

TIA

Spaced
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by spaced. 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.
The help from Microsoft is usually very good.

Have you tried searching on Mail Merge in the help for Word or Excel?

If not go to the Microsoft web site and try putting Mail Merge in there. Here are some I found

http://office.microsoft.com/en-us/assistance/H A010349201033.aspx

http://office.microsoft.com/en-us/assistance/C H060832701033.aspx

http://support.microsoft.com/default.aspx?scid =%2fdefault.aspx%3fscid%3dfh%3bEN-US%3bwd2002m ail
I wrote this up for my work colleagues, it may point you in the right direction.

Mail Merge

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 !!!!!!!!

1 to 2 of 2rss feed

Do you know the answer?

Mail merging - Excel and Word

Answer Question >>

Related Questions