Sub
Makro1()
ActiveDocument.MailMerge.MainDocumentType = wdNotAMergeDocument
ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
ActiveDocument.MailMerge.OpenDataSource Name:= _
"C:\Users\ich\Desktop\quelle.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=C:\Users\ich\Desktop\quelle.xls;Mode=Read;Extended Properties="
"HDR=YES;IMEX=1;"
";Jet OLEDB:System database="
""
";Jet OLEDB:Registry Path="
""
";Jet OLEDB:Database Password="
""
";Jet OLEDB:Engine "
_
, SQLStatement:=
"SELECT * FROM `Tabelle1$`"
, SQLStatement1:=
""
, SubType:= _
wdMergeSubTypeAccess
ActiveDocument.Fields.Add Range:=Selection.Range, Type:= _
wdFieldAddressBlock, Text:= _
"\f "
"<<_COMPANY_"
& Chr(13) &
">><<_FIRST0_"
& Chr(13) &
">>"
" \l 1031 \c 2 \e "
"Deutschland"
" \d"
End
Sub
Sub
Makro2()
With
ActiveDocument.MailMerge
.Destination = wdSendToPrinter
.SuppressBlankLines =
True
With
.DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End
With
.Execute Pause:=
False
End
With
End
Sub