Word MailMerge from SQL

See more:

VB

The single hardest thing I've attempted so far... There are many articles out there on how to do this when pulling from an access database but when your data source changes is a SQL backend all bets are off.

I am looking to use my vb Program to feed the data source for Microsoft mail merge.

Also, it's important that I don't have to use a DSN or any kind of hard connection file. I must be able to use something like this:

SQLcn As SqlConnection = New SqlConnection(Server=SERVER\DB;Database=DATABASENAME;Trusted_Connection=True;)

Any and all help would be greatly appreciated. I've spent hours and hours looking for an answer and have found nothing but roadblocks.

Greatfully,

~Jack