RIAS
asked on
Word Template Mail merge with vb.net
Hello,
Any suggestion how can I do mail merge (word) with vb.net and sql server query.
I have a word template which uses access db.But, now need the vb.net app to connect it with the sql server db.
Cheers
Any suggestion how can I do mail merge (word) with vb.net and sql server query.
I have a word template which uses access db.But, now need the vb.net app to connect it with the sql server db.
Cheers
ASKER
Ok, will give a go.
Need to intiate this from my vb.net app.
Any suggestions
Need to intiate this from my vb.net app.
Any suggestions
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Icohan,
Right now the word is not connected to vb.net.Its a standalone template with connection to access.
I have to now do this:
vb.net app ----connects to word ---which has the sql connection instead of Access
Cheers
Right now the word is not connected to vb.net.Its a standalone template with connection to access.
I have to now do this:
vb.net app ----connects to word ---which has the sql connection instead of Access
Cheers
https://support.office.com/en-us/article/Change-the-main-data-connection-to-another-Microsoft-Access-database-12376f25-3f74-407e-8ca5-53409cc2bcc3
Just look under "Change the main data connection in the form template" from above links where step 3. says: "3.On the next page of the wizard, click Database (Microsoft SQL Server or Microsoft Office Access only), and then click Next." so just select your SQL Server database and go from there.
And make sure you keep a copy of your original template somewhere safe before making/saving any changes.