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 Macro3()
'
' Macro3 Macro
'
ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
ActiveDocument.MailMerge.OpenDataSource Name:= _
"D:\My Documents\essai.xls", ConfirmConversions:=False, ReadOnly _
:=False, LinkToSource:=True, AddToRecentFiles:=False, PasswordDocument:= _
"", PasswordTemplate:="", WritePasswordDocument:="", _
WritePasswordTemplate:="", Revert:=False, Format:=wdOpenFormatAuto, _
Connection:="Entire Spreadsheet", SQLStatement:="", SQLStatement1:=""
ActiveDocument.MailMerge.EditMainDocument
ActiveDocument.MailMerge.Fields.Add Range:=Selection.Range, Name:="numero"
Selection.TypeText Text:=" "
ActiveDocument.MailMerge.Fields.Add Range:=Selection.Range, Name:="image"
Selection.TypeText Text:=" ..................."
aaa = "D:\My Documents\image001.gif" ' ceci est un test
' aaa = ???? ........................
' je souhaite attribuer à 'aaa' la valeur du champ 'image' de l'occurence
' active du fichier essai.xls dans laquelle est stockée le chemin + nom
' du fichier de l'image à inserer
Selection.TypeText Text:=" "
Selection.InlineShapes.AddPicture FileName:=aaa, LinkToFile:=False, _
SaveWithDocument:=True
End Sub |
Partager