setting up email in access?

[Mac]

I have a button on a form to run a macro set up to send an email. the macro
(SendObject) is as follows...

To: =[Forms]![Form Name]!
Subject: Your Stuff is Here!
Template File: (assusming this means an email template?) C:\path\filename.oft

When i run the macro i get a "Choose Profile" popup, asking me to choose my
email profile? I'm not sure how to set this up. I use an exchange server.
So, I choose "Exchange" and click "ok".

I then get another popup that says...
Microsoft Office Access can't send this e-mail message.
Before attempting to send an e-mail message from Microsoft Office Access,
resolve the problem identified int eh previous message, or configure your
computer to send and receive e-mail messages.

My computer IS setup.

What am I NOT doing correctly?
Thank.

 

[jake]

The popup profile box indicates Access is looking for a running
version of MS Outlook. You might try installing Outlook and have it up
and running on the exchange server and/or your machine (depending on
whether you are remoting or not). This would eliminate the popup,
although you will get the Outlook security popup unless you disable it
using VBA..

Otherwise you'll want to look for an SMTP email solution - there is
code out there for this.

Hope that helps.

 

[David H]

Forget the SendObject method and use Outlook Automation to send the email. It
does not require Outlook to be running as it will start the application
itself. You'll also have much more control over the MailItem.

These articles will get you started:
http://support.microsoft.com/default.aspx/kb/209948
http://msdn.microsoft.com/en-us/library/bb206737.aspx