schneiderc97
New Member
- Joined
- Jul 5, 2017
- Messages
- 3
I want my excel file to open up a separate word document template and run a mail merge using VBA.
So far I only have the code to open up the word document from excel:
Sub OpenTemplate()
Set appwd = CreateObject("Word.Application")
appwd.Visible = True
End Sub
How do I set the data source (which is the same excel file I am coding in) and run the actual mail merge?
So far I only have the code to open up the word document from excel:
Sub OpenTemplate()
Set appwd = CreateObject("Word.Application")
appwd.Visible = True
End Sub
How do I set the data source (which is the same excel file I am coding in) and run the actual mail merge?
