E-Mailing from access 2

[eatwork]

I was wondering if anyone out there might know of how I can send out multiple emails via ms access forms through code. The situation is that I have a list of employees that need to be reminded of certain tasks based on certain days. On the day in question. I would like to send an email to that employee, and to myself to remind us of the task at hand. If anyone knows of how I can do that, or how to email from access in general, please put up a post. Thank you very much

 

[HarleyQuinn]

Hi,

If you look at faq705-1634 that should point you in the right direction.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[eatwork]

Thank you HarelyQuinn for your reply. Your help is much appreciated. I will try this link out as it seems to be the article I'm looking for. Thanks

 

[eatwork]

Hi HarelyQuinn, I tried that post, but it seems to give me an error with Dim myO As Outlook.Application. Is there a dll or something that I need to add to use that code? Another question I have is whether or not there is a way to send emails directly from access without having to use outlook or mailing program? Thank you.

 

[goodfela26]

You need to have a reference set to use "Microsoft Outlook x.x Object Library". To do so, when you have a vba window open, choose Tools, References, and then find the Outlook reference.

---------------------------------------
Bob Beck
Systems Administrator

 

[SWiebe]

I have figured out how to send multiple emails through access. I would be happy to email the code. However, I cannot disable the Object Model Guardian - that pesky box that comes up for each email sent requiring you to check "yes" to send. Does anyone know how to do this?

 

[goodfela26]

There's a free 3rd party addin that will help with what you need, depending on the way emails are being sent.

http://www.mapilab.com/outlook/security/

I use it and it works well enough for my needs.

---------------------------------------
Bob Beck
Systems Administrator

 

[eatwork]

Thanks for your help goodfela26. I will give your suggestions a try.

 

[goodfela26]

Just to clarify, since I didn't in the second post...

My first post was in response to eatwork. My second post was in response to SWiebe.

I just want to eliminate any possibility for confusion.

---------------------------------------
Bob Beck
Systems Administrator

 

[eatwork]

Hi SWiebe, Thank you for the offer. Would you be able post the code to help others? thanks.

 

[PHV]

You may also consider the DoCmd.SendObject method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886