Vb Mail Merge To Word

Hello all.

Ive seen this question posted everywhere and so far i have seen no working solution.

I have a spreadsheet and im would like to mail merge it at the click of a button. I am fully aware of how to create a mail merge from word to excel but not from excel to word.

The main reason for this is user friendliness. I'd rather the user press the button and presto, rather than open word --> make doc --> mail merge --> select fields ...

I'd be greatfull for a solution

Thanks B

Re: Vb Mail Merge To Word

Thanks i was unsure whether it would go into Excel because it kind is Excel vba or whether it would go here. thanks