Excel Sales to Mail Merge (1 Viewer)

[YNWA]

Hi,

I am attempting to create a mail merge or similar whereby I can take my excel sheet with a list of sales on and create invoices for each sale at the click of a button.

In my head I want to export fields such as name, address, product, price etc... from excel to a Word Invoice template so I can print the invoices and PDF them.

Does anyone have any tips, examples I can take a look at?

Or is there a better, easier way of getting my sales from Excel to Word and to print/PDF?

Thanks

 

[YNWA]

Or is it possible in Excel to take a sales sheet and export each row to a Invoice Template within Excel itself? Click a button and it runs through each row creating an invoice for the data you need on the invoice?

 

[YNWA]

Any joy peeps?