E-mail & HTML

[Sally B]

How can I FAX and e-mail reports from the program. And
how can I export to HTML format?

 

[Cheryl Fischer]

There are a couple of ways to integrate email capability into Access.

The first is the SendObject method,. SendObject allows you to attach the
data in a table, query, report or other Access object and to select the
format of the output, which can include HTML.

In addition, one can send emails using Automation with Outlook. Automation
affords the developer more capability and control in creating emails than
does SendObject. There is sample code at the following links that can get
you started:

MSDN article on creating appointments, emails, etc., using Automation
http://tinyurl.com/2knwj

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881


Also, have a look at Tony Toews' email page:

http://www.granite.ab.ca/access/email.htm

 

[Sally B]

Thanks Sally,

You are so kind.

-----Original Message-----
There are a couple of ways to integrate email capability into Access.

The first is the SendObject method,. SendObject allows you to attach the
data in a table, query, report or other Access object and to select the
format of the output, which can include HTML.

In addition, one can send emails using Automation with Outlook. Automation
affords the developer more capability and control in creating emails than
does SendObject. There is sample code at the following links that can get
you started:

MSDN article on creating appointments, emails, etc., using Automation
http://tinyurl.com/2knwj

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881


Also, have a look at Tony Toews' email page:

http://www.granite.ab.ca/access/email.htm



--

Cheryl Fischer, MVP Microsoft Access






.