Excel Database to Word Mailing letter using office 2003

[Alfredo]

Ok I'm pretty new when it comes to word.

I have in excel a sheet as follow:

Column A B C
D
Company name Customer name Street address City, State zip


What I want to do is, to transfer the information from excel and arange it
as follow

{Company Name}
Att: {Customer Name}
{Street Address}
{City, State Zip}

Dear Mr./Mrs. {customer name}

[this is the letter]

does anyone have a way to do it I'm sure it's easier than what it looks like

 

[Doug Robbins - Word MVP]

Mail merge is designed to do just that.

See the article "How to create a Mail Merge†at:

http://www.word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com