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
| Sub LancePuplipostageBO_p2() 'Enregistrée le 10/03/2012
'*** Lancer le publipostage des concours.
ActiveDocument.MailMerge.MainDocumentType = wdCatalog
ActiveDocument.MailMerge.OpenDataSource Name:= _
"D:\10_Base_Résultats.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="""";User ID=Admin;Data Source=D:\10_Base_Résultats.xls;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLED" _
, SQLStatement:="SELECT * FROM `Résultats$Print_Area`", SQLStatement1:="" _
, SubType:=wdMergeSubTypeAccess
ActiveDocument.MailMerge.Execute Pause:=True
'*** Aller au signet "Répertoire" du document "21_BO_Admissibilité_p1.doc".
Windows("21_BO_Admissibilité_p1").Activate
'Selection.GoTo What:=wdGoToBookmark, Name:="Répertoire"
Selection.Find.ClearFormatting
With Selection.Find
.Text = ""
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchByte = False
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = False
.MatchFuzzy = False
End With
'*** Coller ler les données du catalogue1 (données du publipostage).
'Selection.PasteAndFormat (wdPasteDefault) |
Partager