Email Reminders 2

[susanlang]

I have to be able to my access database to email reminders when something is due for renewal. I can't seem to get this to work and I was wondering if anyone could give me some pointers.

Many Thanks

Susan

 

[KenReay]

Hi

Which bit don't you understand?

Make a query to select a record set of what needs reminders

Use DoCmd.SendObject to send the EMails

If you want to do something more clever, you may need to use Outlook automation, but sendobject is usually adequate Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[SBendBuckeye]

Hello Susan,

Check out this thread. It has some pretty comprehensive examples in it: thread702-396121

Good Luck! Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!

 

[glrpfi]

If you want to accomplish it without regard to what the default email is on any given machine on the network, the Mabry utility allows you to pipe it directly through and smtp mail server, and the code slips into event-based procedures very well. Give me a yell if you need help.