[AccessD] HTML Email from Access

Andy,
 
Another option is to use XML.

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 

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


I can answer one part of your question (not the email HTML part). A very
simple way to mix static text and variables is to create the text with
markers, such as the following:
 
Dear \\FirstName\\,
Thank you for purchasing a \\ProductName\\. We appreciate your
\\ProductPrice\\.
 
Assign the text to a variable, then execute a series of Replace()
function calls, one for each marker. 
 
As to the other part, how to write the message itself as HTML, I'm eager
for the answer too. What really baffles me is how to include pictures
etc. instead of references to files on a particular hard disk, which may
not be accessible from the outside world.
 
Arthur

	-----Original Message-----
	From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
	Sent: 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
	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030730/4f22bd66/attachment-0001.html>