I'm currently working on a project where i need to automate opening of documents, and mailmerge from an Access database utilizing VBA. The opening of documents part is working as intended, but i'm getting stonewalled when it comes to automatic mailmerge.
I've tried diffrent solutions now, but nothing seems to work for me.
The last thing i tried was to add a module to NORMAL where the following code where placed:
Public Sub DoMailMerge()
DocName = ActiveDocument.Name
.Destination = wdSendToNewDocument
'Close mailmerge document
The above code seems to work with Word 2000, but not with 2007. I've even tried to add:
ActiveDocument.MailMerge.Destination = wdSendToNewDocument
.destination = wdSendToNewDocument
My experience with VBA is limited so please keep it simple.
Thank you in advance