email address as string

[shaffy08]

I have searched this form and did google and yahoo but to no avail. I'm trying to send a report via email to email addresses listed in the report but I’m not getting anywhere. This is what I have so far....

Function Macro1()
On Error GoTo Macro1_Err
Dim strSendTo As String
strSendTo = ProjectManagerEMail
 
    DoCmd.SendObject acReport, "month", "SnapshotFormat(*.snp)", strSendTo, "", "", "", "", False, ""
 
 
Macro1_Exit:
    Exit Function
 
Macro1_Err:
    MsgBox Error$
    Resume Macro1_Exit
 
End Function
 

I also tried creating another table with just email addresses but couldn't get that to work either. please help. What am I doing wrong?

To state the obvious: I’m very new at this!

[Minion]

I have searched this form and did google and yahoo but to no avail. I'm trying to send a report via email to email addresses listed in the report but I’m not getting anywhere. This is what I have so far....

Function Macro1()
On Error GoTo Macro1_Err
Dim strSendTo As String
strSendTo = ProjectManagerEMail

DoCmd.SendObject acReport, "month", "SnapshotFormat(*.snp)", strSendTo, "", "", "", "", False, ""


Macro1_Exit:
Exit Function

Macro1_Err:
MsgBox Error$
Resume Macro1_Exit

End Function

I also tried creating another table with just email addresses but couldn't get that to work either. please help. What am I doing wrong?

To state the obvious: I’m very new at this!

I haven't had a chance to test the mailing feature of Access, though I have looked into in recently for a proposed module. Below I will include a couple links I have on mailing from Access that may help you, but first there is something in your code that might be causing you the error.

Try switching the DoCmd line to the following and see if it works out:

DoCmd.SendObject acSendReport, "month", "SnapshotFormat(*.snp)", strSendTo, , , , , False
 

If this doesn't work I would look furthing into the matter with the following links

Sending Email From Access (Advanced)

Sending Email From Access (Beginner)

Hope some of this helps you.

- Minion -

[shaffy08]

Nope, that didn't work :(
I have looked at those two articles before and am currently palying with the code to make it work for me.
There got to be something in between those two methods discussed by the articles you have pasted the url for. I'm think there got to be a way to add couple lines of code to grab the email address from a query, no?

[MMcCarthy]

My first question is where is ProjectManagerEmail coming from? Is this a control on a form? Is the form open?

You have written your code in a function. Where is this function written and how and where is it called?

[shaffy08]

My first question is where is ProjectManagerEmail coming from? Is this a control on a form? Is the form open?

You have written your code in a function. Where is this function written and how and where is it called?

I have a table which contains a filed label ProjectManagerEmail. I created a micro and then converted that to a module. I have very limited programing and access knowledge...function is created by access.

[shaffy08]

report which i would like to email also contains ProjectMangerEmail field.