MailMerge Options?

[DEWright_CA]

Ok, I have a set of templates that were created to work with a Access
Database using MailMerge Functionality. I have moved this database from being
a Access App to a VB.Net Front-End talking to a SQL2K Backend.

What are my options for completing MailMerge functionality in VB.Net?

I am using StrongTyped Datasets for the VB frontend, so is it just a matter
of creating mappings for the fields and doing a find&replace or what??

Thanks for all your feedback!

 

[Peter Huang [MSFT]]

Hi,

Based on my understanding, you are going to perform an mailmerge via
automation Word against a SQL server in VB.NET. You have transfered the
Access database into SQL server database.
If I have any misunderstanding, please feel free to post here.

Here is a link about how to perform a mail merge from vb.net.
How To Automate Microsoft Word to Perform a Mail Merge from Visual Basic
..NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;301656

Also we can just record a macro and perform the mailmerge steps against a
SQL server database via UI. And we will get the vba code to manipulate the
Word OM to do mail merge and then we can convert the vba code to vb.net
which is similar.

Please perform the suggestion above and let me know the result.

If you still have any concern, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.