I would like to know how to merge data contents from an
Excel spreadsheet onto a Word Document Letter? I have
version 97 for both Excel and Word at my office location.
I have 5 columns, Account Name, Address 1, Address 2, and
Branch Officer as the headings on the Excel spreadsheet.
I would like Account Name, Address 1 and Address 2 to be
in the area it normally would be on a letter. I would
like Branch Officer to be on paragraph 3 of the letter
body.

I would really appreciate your help at your earliest
convenience.

Regards,
Monica

Monica,

Did you try the Mail Merge Helper in Word? You can create letters etc
there and you can use your Excel file as the source file.

hth


---
Message posted from http://www.ExcelForum.com/

Monica

Investigate the use of Word's mailmerge feature to get Excel data to labels
and envelopes and into mass mailings.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

Gord Dibben Excel MVP

On Tue, 25 May 2004 08:29:11 -0700, "Monica" wrote:

I would like to know how to merge data contents from an
Excel spreadsheet onto a Word Document Letter? I have
version 97 for both Excel and Word at my office location.
I have 5 columns, Account Name, Address 1, Address 2, and
Branch Officer as the headings on the Excel spreadsheet.
I would like Account Name, Address 1 and Address 2 to be
in the area it normally would be on a letter. I would
like Branch Officer to be on paragraph 3 of the letter
body.

I would really appreciate your help at your earliest
convenience.

Regards,
Monica