Merging excel contents to a Word Letter

M

Monica

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
 
C

Candee

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
 
Top