data from Excel to Word

  • Thread starter Thread starter ram1000
  • Start date Start date
R

ram1000

This may be too much to ask:

I want to take data from an Excel spreadsheet line (xxx) and place i
in a Word document to print out numerous form letters. For example:

Name: (B3)
Address (C3)
etc. (E3)

After this document is printed I want ot do the same for another line.
At the moment I have to go back and forth transfering data from Exce
to Word.

Thanks yo
 
You may like to look at Word's Mail merge function under tools which will do
what you want.
Rob
 
ram1000 said:
This may be too much to ask:

I want to take data from an Excel spreadsheet line (xxx) and place it
in a Word document to print out numerous form letters. For example:

Name: (B3)
Address (C3)
etc. (E3)

After this document is printed I want ot do the same for another line.
At the moment I have to go back and forth transfering data from Excel
to Word.

Thanks you
Click to expand...

See Word Help and look for <Mail Merge>, that seems what you want.

Rob
 
You want "Mail merge". This is a straight forward process and is explained
in the help files.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Back
Top