1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| Sub envoibonjour()
Dim docWord As Object
Dim appWord As Object
' Démarrer Word
Set WordApp = CreateObject("word.application")
WordApp.Visible = True
'Ouverture du document principal Word
ChangeFileOpenDirectory "D:\CHE15-16\"
Documents.Open FileName:="BonjourREGETNAT.doc", ConfirmConversions:=False, _
ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="", _
PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _
WritePasswordTemplate:="", Format:=wdOpenFormatAuto, XMLTransform:=""
ActiveDocument.MailMerge.OpenDataSource Name:="D:\CHE15-16\nomin15-16 ph1v3.xls", ConfirmConversions:=False, ReadOnly:= _
False, LinkToSource:=True, AddToRecentFiles:=False, PasswordDocument:="", _
PasswordTemplate:="", WritePasswordDocument:="", WritePasswordTemplate:= _
"", Revert:=False, Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";Us er ID=Admin;Data Source=D:\CHE15-16\nomin15-16 ph1v3.xls;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDBatabase Password="""";Jet OLEDB:Engine" _
, SQLStatement:="SELECT * FROM `Listing` WHERE `Journée`= 5 AND `n°club` <> 0", SQLStatement1:="Email", SubType:= _
wdMergeSubTypeAccess
Application.Activate
'SendKeys "{ENTER}", False
With ActiveDocument.MailMerge
.MailAddressFieldName = "Email" 'correspond au nom du champ contenant les adresses mail
.MailSubject = "PUBLIPERSO convocation J5" 'correspond au sujet du mail PUBLIPERSO supprimé par la routine Outlook
.Destination = wdSendToEmail
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With
Application.ScreenUpdating = True
'Fermeture du document Word
ActiveDocument.Close savechanges:=wdDoNotSaveChanges
Word.Application.Quit
End Sub |
Partager