[AccessD] HTML Email from Access

Wed Jul 30 13:02:45 CDT 2003

Arthur,
Here is a quick 'n' dirty method that I use to create an email message with
a picture within Outlook:

Public Sub CreatePictureMail(ByVal strPicPath As String)

    Dim olItem As Outlook.MailItem

    Set olItem = Application.CreateItem(olMailItem)
    olItem.Attachments.Add strPicPath
    olItem.HTMLBody = "<html><img src=" & Chr$(34) & strPicPath & Chr$(34) &
"></html>"
    olItem.Display

    Set olItem = Nothing

End Sub

I'm sure that it wouldn't be a big deal to do this without using look-out.

-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com]
Sent: Wednesday, July 30, 2003 12:52 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] HTML Email from Access

Since I could never figure out how to do it myself, I settled for printing
docs etc. to Acrobat files and attaching those to simple text emails.But I
am following up the Chilkat URL posted earlier in this thread. My client may
be interested in gertting that software. It sure looks like a no-brainer to
use.

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: July 30, 2003 11:08 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] HTML Email from Access

Thanks for the idea Arthur.

I had my money on you for the answer to the HTML bit too. Don't you do that
sort of emailing for concerts? I'm disappointed in you Arthur :-(

--
Andy Lacey
http://www.minstersystems.co.uk

--------------------------------------------------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.
If you have received this email in error please notify the
originator of the message. This footer also confirms that this
email message has been scanned for the presence of computer viruses.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Tappe Construction Co.

Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with 
virus detection software.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030730/6bdddf5a/attachment-0001.html>