Merging excel contents to a Word Letter

  • Thread starter Thread starter Monica
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Cannot type SOME double letters in MS Word 2
Open a word mail-merge document from Excel VBA 1
Mail Merge without using Word 3
Excel Convert word into numbers and back 4
Scrabble Value calculation for Welsh words 0
merge excel and word 1

Back
Top