Sendobject

[saharlan]

Here is my send object line...

DoCmd.SendObject acSendQuery, "FormatClub", acFormatXLS, "<greyhound48@comcast.net>", "<sharlan@allamericaninsurance.net>", , "ACTIVE CONTRACTS", "Please let me know if you see any problems with the attachment.", False

I have this working, but there is a funky thing happening when I send my message.

Outlook pops up a window saying:
" A program is trying to automatically send e-mail on your behalf.
Do you want to allow this?
If this is unexpected, it may be virus and you should choose "No".
and there are 3 buttons [YES] [NO] [HELP]

How do I keep this popup message from opening???

Also... when sending a file from a query, is there a way to rename the outputted file. I'd like to append the date to the end of "FormatClub" so it shows up as "FormatClub-jan/23/2004".

Thanks in advance.

 

[=TB=]

This is real annoying came in with service pack 2, I am 99% sure there is no way of turning this feature off from with stand alone Outlook, though I belief you can if you are using Exchange Server.

Here are 2 very different possible (if not ideal) workarounds.

http://www.express-soft.com/mailmate/clickyes.html

http://www.dimastr.com/redemption/

I have personally just put up with it since it was introduced with the hope that Microsoft will one day soon introduce a simple workaround to it.

 

[modest]

Why would they produce a simple workaround to something they wanted?

Do we not realize the reason for this? Let's not forget that more and more people are becoming better programmers, more and more people are using Access/Outlook...and more and more people are spamming.

Spam has deteriorated idealistic ways of the internet. Your harmless email account is now bombarded from places you don't know, sex ads, product advertisements, loan approvals, etc.

But yes, there are those of us that actually need to mass-mail to people we know. Just saying, normally when Ms puts it in, they make it hard to go back to the way things were. Take for instance the new keyboard layouts for the function keys.

 

[Crilen007]

Aye, but you should beable to tell it that "this program is ok".

Like a firewall.