Help needed to send report via email!!!

[Newguy28]

Hi Guys,

Im new to access and i have a problem!! I have a report that i need to be sent out monthly to 3 people. The problem is i dont know where to start. I have been looking through the forum, but nothing that i can get my head around, so there anyone out there who can help???????

Thanks in advance!!!

 

[freakazeud]

Hi,
what do you mean with auto send?
Will there be NO user interaction? For access to execute a task it has to be opened, so either a user has to open the db and an action can be done automatically or the user can execute an action manually, or you can open the db with the windows scheduler and execute a task automatically.
So let me know which route you want to go...so we can keep going!
HTH
Good luck

 

[Newguy28]

Well i will be going into the database and would like the email sent then automatically,

Thanks.

 

[freakazeud]

So either you can execute this code from an autoexec macro (which will run everytime the db opens) or on your first form's on open event!
Something like this:

Dim strToWhom As String
Dim strMsgBody As String
If DCount("YourIDfield", "qryyourquery") >= 1 Then
strToWhom = "The e-mail addresses of your three people!"
strMsgBody = ("Your Body here...something like here is your info...check attached!")
DoCmd.SendObject acReport, "YourReport" ,acFormatRTF, strToWhom, , , "Your Subject goes here...Hey guys check out the report!!", strMsgBody, True
End If

AirCode and untested...
HTH
Good luck