run word mail merge from excel

[mohamed ali abdelgawad]

hi all
i have sheet witch contain data and i fill data on it then it's calculate , finally i close it and go to word document witch already have letter mail merge , then i print some of it , maybe record #1 , maybe from record 1 to 50.


i want to use macro to run it from excel to
1.run mail merge directly
2.and give me chaise from record : to record.
3.and open it as pdf file.


i searched a lot and find many macros but no one worked with me
so please help me
sorry if my English not good

 

[ranman256]

go into word,
start recording a macro,
run your mail merge
stop recording,
alt-F11 (vbe)
get the code created in a module, copy all code

back in excel,
paste the code,in a module, in the section below that takes control of Word...

                    '*****  YOU MUST HAVE :  MS WORD xx.x OBJECT LIBRARY  checked in VBE menu, tools, references.  *****


sub Macro()
Dim objWord As Word.Application
Set objWord = CreateObject("Word.Application")


With objWord
    .Visible = True


    Set doc = .Documents.Add
 
    'ADD YOUR CODE HERE


    'doc.SaveAs CurrentProject.Path & "\TestDoc.doc"
End With
end sub