DoCmd.SendObject - email being 'sent' but not received ?

[liamfitz]

Here's my code for sending e-mail (OUTLOOK) using ACCESS 2010.

Public Function Email_Via_Outlook(varAddress, varSubject, varBody)
DoCmd.SendObject , , , varAddress, , , varSubject, varBody, False
End Function

--------------------------------------

Call Email_Via_Outlook("[EMAIL="Will.Davies@advocacyforall.co.uk"]Will.Davies@advocacyforall.co.uk[/EMAIL]", "Test e-mail for AfAIS Database Referrals", "Referral No. 1FB060612 was referred 14 days ago. Status remains unassessed. Thank you")

E-mail is showing in 'Sent' folder of machine where Access is running, but not the recipients Inbox (OUTLOOK). Any ideas ? Thanks.

 

[michaeljryan78]

I had helped somone with a similar question just a couple of day ago. You may want to create a separate piece of code to send email and create an instance of outlook. THis is a bit more robust.

http://www.access-programmers.co.uk/forums/showthread.php?t=228287