Macro errors before save of mail merge document

Hi Everyone,

I am having problems with my latest macro. It is a mail merge from excel to merge fields in MS Word. The merge works correctly, but I want the word file to save to a specific folder with a specific name as defined by the contents of cell C52 on my "form" worksheet. I have borrowed from another macro I am using to create a directory and name my excel file. That code is here:

Please Login or Register  to view this content.

My mail merge macro fills in the fields but errors out before the save on the line denoted with **. The error listed is 438 - Object doesn't support this porperty or method...

Can anyone help me sort this out?

Please Login or Register  to view this content.

Thank you very much,

Patrick

I think you can't refer to wd because wd is the application and not the active document. You can try to change the row:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

Regards,
Antonio

Thank you for the reply. After the changes you suggested, I no longer get the error. The file is saving but not to the desired location. I am not sure what I need to change to get the merge document to save in the directory created by my 1st macro. Any other suggestions?


Thanks,
Patrick