Hi everyone. I have a spreadsheet that has a name, address, postal code and some figures that I need to put into a standard letter. It is just one record i.e. one person, and one set of prices that go into the letter (which is a quote). I'll call the spreadsheet "Costs" and the word document "Letter".
So very simply I want to have a button on the spreadsheet that when you click it does the following:
1. It opens the Word document called Letter
2. It mailmerges the data into the Word Document Costs for review.
That's all I want it to do.
Is this easy or difficult to do. I'm not so good with VBA as I'm only just starting to try to get my head around it.
Cheers
John
So very simply I want to have a button on the spreadsheet that when you click it does the following:
1. It opens the Word document called Letter
2. It mailmerges the data into the Word Document Costs for review.
That's all I want it to do.
Is this easy or difficult to do. I'm not so good with VBA as I'm only just starting to try to get my head around it.
Cheers
John
