PDA

View Full Version : print letter address from xcel



hay u
22-01-2004, 12:12 PM
How does one print data you might enter from a spread sheet, on to a separate page in this case,
it would be someone name and address that you have from a invoice spreadsheet to a envelope.

sorry to be a worry.

Marlboro
22-01-2004, 12:45 PM
The easy way of doing what you have suggested is using your MS Excel file as a "Data Source" for a Mail Merge in MS Word.

In Word:

Tools/Mail Merge

In the Mail Merge Window under "Get Data" select "Open Data Source" and find your excel file (you may need to change the data type to find from *.DOC to *.XLS

It's easy from there on.

This will be the best way if you have may names and addresses in your Excel file...