PDA

View Full Version : Merging to a Spreadsheet from word document


Lindsey Hurlstone
Oct 16, 2006, 02:09 AM
I am trying to merge a word document to a single sheet on a spreadsheet. Basically I want to print my invoices out and therefore the information I need to be printed on the invoice is contained under in the company spreadsheet on the sales ledger.

ScottGem
Oct 16, 2006, 06:00 AM
It depends on how the info is laid out in the spreadsheet. If its laid out in table form, you may be able to use the Mail Merge feature in Word to pull the info.

However, if your invoices contain multiple items, that will probably not work. You may be better off creating your invoice in Excel.

Or, better yet, move the sales ledger to Access.

Dale F Wiley
Oct 31, 2006, 02:21 PM
Hi Lindsey,

The simple thing to do is would be to select all the data you want to put in the spreadsheet then Paste it into Excel.

This would work a lot better if the Word data was in tables.

Good luck.

Dale :cool: