newbie question about E-mail

[Guest]

I'm trying to convert an old booking system to Access for Children's Theatre
of Charlotte's school performances (professional productions for youth).
Tables will (should?) include Schools (i.e. customers), ShowTitles (i.e.
catagories), PerformanceDateTimes (i.e. products), Contacts (multiple people
book from the same school), Bookings (i.e. orders) ... if we have e-mail
addresses as a field within a Table (or two), can Access create an "e-mail
reminder" that would go to the contact a certain number of days before they
were scheduled to come to a show? We do use Outlook and Exchange...

Thanks!

Rob Odum

 

[Guest]

Hi Rob,

Yes, provided you have a default email client recognised by Windows - for
example Outlook or Outlook Express. You may need to write some VBA code
(very straightforward) using the SendObject method. Beware that you will get
a message saying that a program is attempting to send an email on your behalf
to which you have to agree so the process cannot be fully automated.

Regards,

Rod

 

[Guest]

Rob & Rob,

I've been able to bypass the "message on your behalf" warning by modifying
my security settings. Now, I wouldn't necessarily recommend this approach,
but you can make the changes in the Trust Center in Outlook. For example, in
Outlook 2007, you'd go to Tools: Trust Center: Programmatic Access and choose
"Never Warn." I know there is a similar option in Outlook 2003, as well.

Hoep this helps.
Deanna

 

[Terry Kreft]

I don't believe there is a similar setting in Outlook 2003 at all.