[AccessD] HTML Email from Access

Hi Andy

I', just completing something very similar to this.  It sends the emails via Outlook and I have a page for adding attachments etc also.  I'm still fine tuning it, but if you would like to see where I'm at I'd be happy to send you it (I'll be away for a day so there'll be a delay).  Let me know.

Cheers
Selina

--------------------------------------------------------------------------------
        Selina Iddon 
      selina at easydatabases.com.au
     Ph: 0414 225 265
      Easy Access Databases   

  ----- Original Message ----- 
  From: Andy Lacey 
  To: Stuart McLachlan ; "accessd at databaseadvisors.com"@smithers.nildram.co.uk 
  Sent: Wednesday, July 30, 2003 9:25 PM
  Subject: Re: [AccessD] HTML Email from Access


  Hi Stuart
  Thanks for the reply.
  I'm about to visit a potential new client who is looking to replace an off-the-shelf contact management system withan Access app. Good news for me I hope. Anyway one of the requirements is to be able to prepare HTML emails (text and pics and anything else I guess) with, in effect, field placemarks (e.g. [CustomerName] or whatever). It then has to do an "emailmerge" between the HTML and the data and send to all on his list. Does that make sense? What do you think?

  I've kept this on-list for now as it better explains (I hope) what I'm trying to do and there may be others out there who can help or want to see where the discussion leads.

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




    --------- Original Message --------
    From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
    To: "Andy Lacey" <andy at minstersystems.co.uk>, "accessd at databaseadvisors.com" <accessd at databaseadvisors.com>
    Subject: Re: [AccessD] HTML Email from Access
    Date: 30/07/03 11:03


    On 30 Jul 2003 at 11:37, Andy Lacey wrote:

    >
    > Morning all
    > Any one have any experience of sending out HTML email-shots from
    > within Access. I already use automation to drive Outlook but have
    > only ever sent text emails. How would I (or more likely the user)
    > format HTML emails? In Word or what? And how would I merge data fom
    > the Access database with it ("Hi Bill" etc) and send them via
    > Outlook? Any ideas? Anyone doing it already? Any guidance would be
    > gratefully received.
    >

    I do it in a number of different ways.

    I have a small PB application which interrogates a Contact list and
    sends out to everyone with a certain "category" in the the contacts
    list. It is designed to compose the html mail in Outlook which is
    then saved to a HTML file.

    I've also done it by creating a report and using Docmd.SendObject to
    each one in turn with a single page report output as HTML.

    Email me off-list with more info on exactly what you are trying to do
    and I'll fire something through to you.

    (I do it under protest for a client , but I personally have an
    aversion to html emails <g>)


    --
    Lexacorp Ltd
    http://www.lexacorp.com.pg
    Information Technology Consultancy, Software Development,System
    Support.



    _______________________________________________
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com








------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030731/27763eab/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: small_logo.jpg
Type: image/jpeg
Size: 1219 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030731/27763eab/attachment-0001.jpg>