EMail Button configuration

[Steve]

I am trying to email form data to a known recipient and I've been able to
just launch the "Outlook 98". I would like to interject stuff that is within
the present record.

Example:
I log a critical process modification within the database. When I
finish updating the record, I would like to email (Button) the information to
a known email address.

I've added the "mail button" but presently it will only open Outlook 98.
(Multiple copies of O98 if I keep hitting the button)

Thanks in advance.

Steve

 

[Sandra Daigle]

Hi Steve,

You didn't post your code so I'm not sure what your doing but here are some
links to articles that should give you some ideas on how to create email
using Access:

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

Outlook for the Summer (Programming Microsoft Outlook Objects)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office071299.asp

For even more ideas take a look at this site:

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm

 

[Steve]

WoW, That was fast!

Thank you very much for the quick responce.

I haven't gone through each line item yet but I did have a change to try
the first link.

unfortunetly, I got the error...

Compile error
Expected variable or procedure, not module

[OK] [Help]

Thanks Sandra

Steve

 

[Sandra Daigle]

Hi Steve,

What line caused the error? Where did you put the code and how were you
calling it? Anytime you have code related questions its a good idea to post
the code too since eventually we're going to ask for it anyway

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

WoW, That was fast!

Thank you very much for the quick responce.

I haven't gone through each line item yet but I did have a change to
try the first link.

unfortunetly, I got the error...

Compile error
Expected variable or procedure, not module

[OK] [Help]

Thanks Sandra

Steve

Hi Steve,

You didn't post your code so I'm not sure what your doing but here
are some links to articles that should give you some ideas on how to
create email using Access:

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

Outlook for the Summer (Programming Microsoft Outlook Objects)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftal
k/html/office071299.asp

For even more ideas take a look at this site:

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm

 

[Steve]

I followed to example in "Q161088 Using Automation to Send a Microsoft
Outlook Message" line for line

I did a copy-paste for the code.

I didn't experience anything that was in the least bit questionable and the
error message popped up.

So, I didn't change anything from the example.

 

[Sandra Daigle]

I just copied the code into a brand new standard module, then compiled it,
then ran it from the immediate window - no problems. It is not clear to me
what you are doing when this error occurs.

Also, make sure you followed step 5 of the kb article:

"In the References box, click the Microsoft Outlook 8.0 Object Model and
then click OK.

NOTE: If the Microsoft Outlook 8.0 Object Model does not appear in the
Available References box, browse your hard drive for the file Msoutl8.olb.
If you cannot locate this file, you must run the Microsoft Outlook Setup
program to install it before you proceed with this example. "

Where did you put the code that you copied? Into the form's class module or
into a standard module?

 

[Sandra Daigle]

Also make sure that your module does *NOT* have the same name as the
procedure - that will cause this error.

 

[Steve]

Also make sure that your module does *NOT* have the same name as the
procedure - that will cause this error.

Thanks Sandra,

I'm not sure what the problem was but I found "Msoutl85.olb" and everything
worked.

Thank you very much, your a jewel.

Steve