Mail merge from word using sql server express and vb.net 2005

[steve]

Hi All

What is the word mailmerge.opend atasource syntax when using sql server
express as the data source

Below is the code when using access....
odoc.MailMerge. OpenDataSource( Name:= _

"C:\Program Files\Geelong Microsolutions\ Haircuts\Data\u 2.mdb",
ConfirmConversi ons:=False, _

Connection:= _

"Provider=Micro soft.Jet.OLEDB. 4.0;Password="" "";User ID=Admin;Data
Source=C:\Progr am Files\Geelong Microsolutions\ Gym
Master\Data\u2. mdb;Mode=Read;J et OLEDB:Engine Type=" _

, SQLStatement:=" SELECT * FROM `Customers`", SQLStatement1:= "")

Regards

Steve

[Peter Huang [MSFT]]

Hi Steve,

Based on my understanding, you want to mailmerge against a SQL 2005 Express
DB and you want to know what is the parameter for the OpenDataSource.

Word provides strong Macro record function, we can simple use that function
to record the macro that we do the mailmerge against SQL 2005 Express DB
manually and get the code we wants.
1. Tools/Macro/Record New Macro
2. Run the MailMerge in Word by manually
3. Stop the macro recording
4. Press Atl+F11 to View the Recorded macro

Here is an example I record for your reference.

Sub Macro1()
'
' Macro1 Macro
'
ActiveDocument. MailMerge.MainD ocumentType = wdMailingLabels
ActiveDocument. MailMerge.OpenD ataSource Name:= _
"<path to a odc file>" _
, ConfirmConversi ons:=False, ReadOnly:=False , LinkToSource:=T rue, _
AddToRecentFile s:=False, PasswordDocumen t:="",
PasswordTemplat e:="", _
WritePasswordDo cument:="", WritePasswordTe mplate:="",
Revert:=False, _
Format:=wdOpenF ormatAuto, Connection:= _
"Provider=SQLOL EDB.1;Integrate d Security=SSPI;P ersist Security
Info=True;Initi al Catalog=encrypt ;Data Source=<sqlexpr ess instance>;Use
Procedure for Prepare=1;Auto Translate=True; Packet Size=4096;Works tation
ID=<machinename >;Use Encryption for Data=F" _
, SQLStatement:=" SELECT * FROM ""employee2 """, SQLStatement1:= "",
SubType _
:=wdMergeSubTyp eOther
End Sub

Please have a try and let me know the result.
If you have any concern, please feel free to let me know.
Best regards,

Peter Huang

Microsoft Online Community Support
=============== =============== =============== =====
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=============== =============== =============== =====
This posting is provided "AS IS" with no warranties, and confers no rights.

[steve]

Peter

Thanks for the reply

Problem solved

Regards
Steve

""Peter Huang" [MSFT]" <v-******@online.m icrosoft.comwro te in message
news:14******** *****@TK2MSFTNG XA01.phx.gbl...

Hi Steve,

Based on my understanding, you want to mailmerge against a SQL 2005
Express
DB and you want to know what is the parameter for the OpenDataSource.

Word provides strong Macro record function, we can simple use that
function
to record the macro that we do the mailmerge against SQL 2005 Express DB
manually and get the code we wants.
1. Tools/Macro/Record New Macro
2. Run the MailMerge in Word by manually
3. Stop the macro recording
4. Press Atl+F11 to View the Recorded macro

Here is an example I record for your reference.

Sub Macro1()
'
' Macro1 Macro
'
ActiveDocument. MailMerge.MainD ocumentType = wdMailingLabels
ActiveDocument. MailMerge.OpenD ataSource Name:= _
"<path to a odc file>" _
, ConfirmConversi ons:=False, ReadOnly:=False , LinkToSource:=T rue, _
AddToRecentFile s:=False, PasswordDocumen t:="",
PasswordTemplat e:="", _
WritePasswordDo cument:="", WritePasswordTe mplate:="",
Revert:=False, _
Format:=wdOpenF ormatAuto, Connection:= _
"Provider=SQLOL EDB.1;Integrate d Security=SSPI;P ersist Security
Info=True;Initi al Catalog=encrypt ;Data Source=<sqlexpr ess instance>;Use
Procedure for Prepare=1;Auto Translate=True; Packet Size=4096;Works tation
ID=<machinename >;Use Encryption for Data=F" _
, SQLStatement:=" SELECT * FROM ""employee2 """, SQLStatement1:= "",
SubType _
:=wdMergeSubTyp eOther
End Sub

Please have a try and let me know the result.
If you have any concern, please feel free to let me know.
Best regards,

Peter Huang

Microsoft Online Community Support
=============== =============== =============== =====
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=============== =============== =============== =====
This posting is provided "AS IS" with no warranties, and confers no
rights.