That's a good point I didn't consider actually, I suppose I was trying to make this as easy to do as possible for the document I'm creating. quite surprisingly i've encountered people in admin roles who don't know how to use mail merge and constantly finding people get bored with the process quickly if they have to click more than twice.

On the issue at hand. I'm now getting the following error:

run-time error '-2147467259 (80004005)';

[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.

I've ran the driver manager here: "%SystemRoot%\System32\odbcad32.exe"
And it is correct I have no ODBC driver installed. Strange.
Anyone know where I can get the correct driver?

I did try myself by installing this one:
https://www.microsoft.com/en-gb/down....aspx?id=36434

but no luck

Once set up, using a mailmerge is a trivial undertaking. And, if you want, a macro could be used to make it so simple that all the person using it has to do is open the document. Of course, that also means they get no opportunity to exercise some control over the process...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]