Email report from Access

[smpayne69]

I am emailing a report from access and am getting the following pop-up:

"A program is trying to automatically send e-mail on your behalf. Do you want to allow this?"

How do I get that to not pop-up and spoil my automation dreams???

Help!!

 

[Matt Greatorex]

If you know which part of the code is producing the message, you could add a command to turn the warnings off just before it, thne turn them back on, just after.

I forget the exact syntax, but it's something like

DoCmd.SetWarnings False

 

[smpayne69]

Warnings

I have set Warnings to No in the macro list, but that does not stop it.

 

[Matt Greatorex]

Just to know for sure, have you tried it in the VBA itself?

If there's some problem with the macro, this would identify it.

 

[smpayne69]

Outlook

Actually, the message is from Microsoft Outlook, not Access...sorry, just noticed it.

 

[Matt Greatorex]

Ah...well, I'm sorry but that's beyond my abilities.

Hopefully, someone more knowledgable on that are will answer you.

 

[smpayne69]

Thanks for your help.

Thanks for trying, I appreciate it.

 

[Hayley Baxter]

See the link I posted in the thread below.

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

Hay

 

[Colby]

smpayne69, don't know if you got your email automation working or not; but the below is what I use. I call the vba function from a command button. I don't get any popups.

DoCmd.SendObject _
acSendReport, _
"Prime Distribution", _
"SnapshotFormat (*.snp)", _
"eaddress1; eaddress2;", _ 'this is your TO: line
"eaddress3; eaddres4; eaddress5", _ 'this is your CC: line
"eaddress6", _ 'this is your BC: line
"Subject Line", _
"Message Text", _
False 'shuts off warning


this send the report Prime Distribution to all address as a SnapShot file, you can also use
acFormatSNP, acFormatRTF, acFormatTXT

Please let me know if this helped you out.

 

[Colby]

smpayne69, don't know if you got your email automation working or not; but the below is what I use. I call the vba function from a command button. I don't get any popups.

DoCmd.SendObject _
acSendReport, _
"Prime Distribution", _
"SnapshotFormat (*.snp)", _
"eaddress1; eaddress2", _ 'this is your TO: line
"eaddress3; eaddres4; eaddress5", _ 'this is your CC: line
"eaddress6", _ 'this is your BC: line
"Subject Line", _
"Message Text", _
False 'shuts off warning


this send the report Prime Distribution to all address as a SnapShot file, you can also use
acFormatSNP, acFormatRTF, acFormatTXT

Please let me know if this helped you out.

 

[Colby]

smpayne69, don't know if you got your email automation working or not; but the below is what I use. I call the vba function from a command button. I don't get any popups.

DoCmd.SendObject _
acSendReport, _
"Prime Distribution", _
"SnapshotFormat (*.snp)", _
"eaddress1; eaddress2", _ 'this is your TO: line
"eaddress3; eaddres4; eaddress5", _ 'this is your CC: line
"eaddress6", _ 'this is your BC: line
"Subject Line", _
"Message Text", _
False 'shuts off warning


this send the report Prime Distribution to all address as a SnapShot file, you can also use
acFormatSNP, acFormatRTF, acFormatTXT

Please let me know if this helped you out.

 

[carash77ash]

Current Security Model for Outlook requires that each email message sent from access be approved for sending.

Ash