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.

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.

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: