Mail Merge datasource!

[oka97]

I've noticed you have to set Word's datasource property for it to accomplish a mail merge, but my VB application is connecting to an MDB using ODBC, as such it has no clue where the MDB file is (it'll be somewhere on the LAN).

Isn't it possible to do a mail merge by applying an ADO connection somehow?

I'm guessing no. In which case I'll let the user choose the (LAN) location of the MDB file manually, which isn't as user-friendly as I'd have liked.

Any suggestions people?

 

[oka97]

Ah no, as usual I'm being impatient. Here's the answer

Microsoft Knowledge Base Article - 285332
HOWTO: Automate Word 2002 with Visual Basic to Create a Mail Merge

http://support.microsoft.com/?kbid=285332

Under title "Using ODBC"