 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Publisher / Programming / March 2006Send Publisher In Email Body via VB
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 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. > 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 [quoted text clipped - 5 lines] > > TJ 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? > 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 [quoted text clipped - 5 lines] > > TJ 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! > 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 [quoted text clipped - 9 lines] > > > > TJ
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.