I want to be able to set up an email merge using word and access 2002.
I'd like to send out letters to several individuals but be sent individually and have data pulled from their record like wage, employer etc...

I tried to use my query in my database as my data source but when I go through the mail merge wizard in word it stalls. So I thought maybe I could continue with the mail merge but use excel as the data source but run it through Access.

So this is what I would like the button to do:

When the button is clicked export data from query into excel, saving and closing the spreadsheet. So word can use this as the data source.
Then open my word mail merge template.

If there is a much more efficient way of doing this please let me know. I'm open to any ideas. I just want to send out personalized emails from access to contacts.