Mail merge is designed to do just that.
See the article "How to create a Mail Merge€¯ at:
http://www.word.mvps.org/FAQs/MailMe...AMailMerge.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
"Alfredo" wrote in message
...
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