Merging excel contents to a Word Letter
 

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

Merging excel contents to a Word Letter
 

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/

Merging excel contents to a Word Letter
 

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