Send Publisher In Email Body via VB

[T. Hahn]

I am planning on writing an app. to open a Publisher File and send in an
email message body to a recordset of addresses (one at a time). I know the
code to create/send messages through Outlook, but my question is, How do I
refference Publisher to add a specified file to the body of that message?
Still in the development stages and looking for direction.

Thanks,

TJ

 

[T. Hahn]

Is the sending of Publisher files via email a function of Publisher or is
that through Outlook. I am not seeing any functions in the Publisher 11.0
Object Library relating to email. Should I be exporting the Publisher File
as HTML then creating an Outlook object from that html???? Has anyone else
tried this? I would really like to do this since the TO: Field inside of
Publisher field has a 40,000 character limit, pending on our promotion, we
might be sending to 2,000+ email addresses.

 

[MaddieJ]

Did you ever solve this problem - I would like to be able to do something
like this & am having trouble finding any sample that I could use to get me
started?

 

[T. Hahn]

Hi! I have resolved this issue, but in a very 'round about way. I worte an
application that uses the Publisher 11, Excel 11, and Word 11 reference
libraries. The application first generates a query to extract targeted email
addresses, then exports them to an excel document (along with any other
information you want attached in the email). Then the app opens the publisher
file and saves it as an html file (Publisher automatically creates a folder
in the same directory as the publisher file with a html file and a jpg of the
publisher document). From this point I open word, generate a document based
off of the html publisher file, create an email mailmerge referencing the
excel document for email addresses, names, street addresses, etc. The user
will then preview the document and click "Mail merge" to send the emails (by
doing so, you bypass the security prompts in Outlook 2003).

There are plenty of websites with code examples to do these steps, but you
will need to customize it to fit your needs.

Hope this helps!