Hi, guys,

I’m having trouble with VBscript and Microsoft publisher file. I'm modifying a MS Access application (there are GUI forms built in). This was created by somebody else and was used by salesmen sending Bulk emails. It retrieves a file (could be word, publisher, etc) from File Browsing form. Then, it retrieves a list of emails from a MS excel sheet. Finally, the word or publisher gets sent out to all the recipients. The code behind this is VBscript.

The problem is the salesman wants to send a Publisher file (not as an attachment but an actual content of email). However, the recipients receive the publisher file as an image which means the hyperlinks on publisher file don’t work on the recipients’ side (of course, we can always use HTML file to accomplish that but the salesman really wants to use Publisher file). I can make this happen through Outlook ("Actions" on the top of outlook toolbar -> "New Mail Message Using" option -> "Microsoft Office" option -> "Microsoft Publisher Publication" option). After selecting all these options, the recipients can receive the file as a publisher file and all the hyperlinks work. However, I have to implement this in VBScript so that this Access application can perform the same action.

Does anyone have such experience? any advise would be appreciated!

Thanks a lot,
Bin