Using Word Macros With Mail Merge

[bobsmallwood]

I've created a macro with mail merge that always creates Microsoft Visual Basic Run Time error 5852: "Requested Object is not available" with a pointer on the command ".Destination = wdSendToNewDocument". Can this be overcome some way?

 

[SkipVought]

Hi,

Please post htis question along with ALL your code in the VBA Visual Basic for Applications (Microsoft) Forum707

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[macropod]

Hi Bob,

You don't say which version of Word you're using, but there are various MSKB articles relating to this problem, and how to overcome it. I suggest doing a search there on MS Word, looking for:
mailmerge 5852
and/or:
vba 5852

Cheers

 

[bobsmallwood]

Thanks, Will do.