I'm having problems with Mail Merge. When I click on Mail Merge when I have a query open with the data I want to include in the email Word opens with pop up dialog box "confirm data source" with OLE DB Dabatabase Files as the only option. When I click OK the icon for Access starts flashing in the task bar with pop up message "Word was unable to open the data source" Do you have any idea why this is happening. Right now my work around is to export the query to excel and then use it as the data source for my mail merge. I'm only on the 3rd video so I'm sure one of your other email methods will meet my needs better but I would like to know why I am getting this error.

Thanks - your videos are awesome
Kim

---

Reply from Alex Hedley:

Does your Query contain a Parameter?

MS Article should help.