1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
' Macro1 Macro
' Macro enregistrée le 24/08/2006
'
ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
ActiveDocument.MailMerge.OpenDataSource Name:="", ConfirmConversions:= _
False, ReadOnly:=False, LinkToSource:=False, AddToRecentFiles:=False, _
PasswordDocument:="", PasswordTemplate:="", WritePasswordDocument:="", _
WritePasswordTemplate:="", Revert:=False, Format:=wdOpenFormatAuto, _
Connection:= _
"DATABASE=contact;DSN=test;OPTION=0;PWD=monpwd;PORT=3306;SERVER=localhost;UID=root" _
, SQLStatement:= _
"SELECT contact_0.civilite_contact, contact_0.nom_contact, contact_0.prenom_contact, contact_0.fonction_contact, contact_0.titre_contact, contact_0.ville_contact, contact_0.cp_contact, contact_0.adresse_contact, contact_0.portable_contact, contact_0.fixe_c" _
, SQLStatement1:= _
"ontact, contact_0.mail FROM contact_du_gt.contact contact_0 WHERE (contact_0.fonction_contact Like 'm%') ORDER BY contact_0.nom_contact, contact_0.prenom_contact" _
, SubType:=wdMergeSubTypeOther |
Partager