Send Email with Access
I'm working in a database that need to send some email daily to some person. I ready have one that is to Excell. My question is. Can I use the same routine or is something different. Thanks in advance,
Marce
Software
I'm working in a database that need to send some email daily to some person. I ready have one that is to Excell. My question is. Can I use the same routine or is something different. Thanks in advance,
Marce
by adlan_marce Accepted solution
by thumbsup2 Accepted solution
..... without knowing what routine you're using in Excel to send the mail, .... without knowing what version of Office you're using, ..... without knowing what operating system you're using, .... etc, ...etc, ....
We're not psychic, sorry.
by craig Accepted solution
Had the same problem with my app, which emailed people reminders from an Access database. You will need to write some code in VBA. First solution I tried was to use MAPI command from access (see http://www.blueclaw-db.com/access_email_send_outlook.htm) which uses your Microsoft Outlook server to send email from any VBA apps. Trouble is you will need to configure access to use these commands by referencing in the Outlook Object. Another problem is Outlook's security will prevent or restrict emailing unless it's security level is reduced to LOW.
Alternatively, use can use an SMTP mailer such as KwikEmail to SHELL from a VBA app and distribute your email without using Outlook. This will prevent annoying security prompts and pop up messages, and does not need any special configuration from Access.
This discussion is closed to new replies.
Sort by Trending