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.

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.
