[AccessD] HTML Email from Access

David
Excuse my ignorance but I don't understand the impliction of using
sockets rather than mapi. Could you explain? What is the impact
regarding the customer's email client? Does it get bypassed? If so where
is the record of what got successfully sent? It might be very useful
because I'm concerned about the sheer volume of emails which would build
up in the Sent Items folder.
 
Andy Lacey
http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/>  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Phelan
Sent: 31 July 2003 02:44
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] HTML Email from Access


Andy,
 
I have code which I use in a small vb app I wrote to send monthly
reports. It uses sockets instead of mapi and is set up for command-line
use. The body of the email is sent in html and the code could be adapted
to work in your situation. Let me know off-line if you'd like the code.
 
Dave

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
Sent: Wednesday, July 30, 2003 7:25 AM
To: Stuart McLachlan;
"accessd at databaseadvisors.com"@smithers.nildram.co.uk
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 <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
<http://www.databaseadvisors.com/> 







-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030731/70b9f698/attachment-0001.html>