Hi friends,
Greetings from me!
I’m getting compile error ‘user-define type not define’.
Actually it’s a word macro working fine in word. In my project I have to convert several word files to pdf. The main database is in excel file. With mail merge I create several letters for each individual separately. I want to convert it to pdf and send it to the recipients individually.
Now the problem is:
I have to run mail merge to send the document by email to the recipients automatically by running the macros one by one automatically. Everything is working fine but for converting word files I have to stop macro and then open the word file manually; then run ‘convert to pdf’ macro from word file. Then manually open the excel workbook again to send the document to each recipients individually by email.
I want to fully automate the process. So I want to run ‘convert to pdf’ macro from excel workbook so that it will be possible to run it automatically by calling it after previous macro.
Will you please do the necessary amendments to run it from excel?
Any help will be highly appreciated.
Thanking you in anticipation.
Bookmarks