Send mail from Access 2000 using outlook Express 5.5

Posted on 2003-03-02
Medium Priority
Last Modified: 2010-08-05

I have an access 2000 db with email addresses.  These addresses need to receive a monthly HTML newsletter.  My email client is Outlook Express 6 or 5.5

I know you can send an HTML letter using Outlook 2000 by adding a reference to Outlook.Application and objOutlookMsg.HTMLBody = HTML_String.  Is there a similiar reference for Express?

If not how else could I build this HTML newsletter functionality using Access 2000 and Express 6.0?

Question by:cgibbo
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 23

Expert Comment

ID: 8056790
You could use MAPIMAIL to send using the default email client.  It can be downloaded from www.universalthread.com and is quite easy to use with only a few lines of code.

Author Comment

ID: 8060974

Struggling to find a mapimail download there, found one but it was a Foxpro download.  It also looks l need to pay for the www.universalthread.com site?

I also found an old Experts Exchange thread saying that Mapimail does not work with HTML emails?  Is this correct from your experience?

LVL 23

Expert Comment

ID: 8061551
I wouldn't know that one for sure.  All of the emails I send are plain text and it works great.

Author Comment

ID: 8100259
Is there a one stop shop/website where I can get some information on how to use this mapimail to send emails from Access.  
LVL 23

Accepted Solution

slink9 earned 200 total points
ID: 8102089
If you downloaded it you will have enough sample code and instructions to learn how to use it.  It is a quite simple couple of lines of code.

set classlib to mapimail
local oMapi
oMapi = createobject("CusMapi")
oMapi.SendMail("", "", "address@hotmail.com", "Test Subject", "Test EMail", "", .f., .f.)

That is VFP code.  It comes with VB code.

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Mailbox Overload?
If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Suggested Courses

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question