Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / New Users / November 2005

Tip: Looking for answers? Try searching our database.

Sending E-mailshot using Automation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jon Lewis - 29 Nov 2005 14:38 GMT
I'm writing a routine to send a standard email to a group of customers using
Automation from Access.

If I create my standard email with the required content in the message body
I can save the message as a Outlook Template (OFT file).  Manually I can
then use File>New>Choose Form etc and pick the saved template and the
message content is in the message body as expected.

How can I do this using automation?

If I use the Set objOutlookMsg =
objOutlook.CreateItemFromTemplate(strTemplate) method I get a message based
on my Template (e.g. the Subject field is reproduced correctly) but any text
in the content matter has dissappeared and any graphic objects either appear
as attachments (bmp's) or again have dissappeared (GIF's).

I'm setting the body format to HTML (objOutlookMsg.BodyFormat =
olFormatHTML).

Should I be using a different method?

Also how can I bypass the Outlook security dialog (A program is trying to
access email address's etc.).  The dialog is manageable if I'm using
objOutlookMsg.Save (it fires once per session) but not if I'm using
objOutlookMsg.Send when it fires three times per email!

TIA
Jon Lewis - 29 Nov 2005 14:52 GMT
> I'm writing a routine to send a standard email to a group of customers using
> Automation from Access.
[quoted text clipped - 23 lines]
>
> TIA
 
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.