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