Hi guys

I have a excel spreadsheet which is used to populate data in a Word document as a a Mail merge.

Does anybody know what code I could use to

a) Open the Mail merge document in Word and
b) Run the Mail Merge

Finally if possible i Would like it to print the merged data.

Ideally I would like this to run from a single macro. This would mean the user could press one button and have the data and send it to the printer without doing anthing else.

Any help on this would be appreciated.