Access emails

[Gargen]

Hello,

I built a macro in MS Access to send a lot of emails with files attached to it and so on. I have two questions.

1. How do i turn off the, this program is trying to send an email so on and so forth and i have to press Ok 100 times.

2. Can i make it so that they can't see who sent the email? They reply to all and i get a shitload of emails back right away and i dont want them. I want them to be able to reply to all but if i'm not on the CC of the email, i dont want them replying back to me.

Thanks in advance for the help,

Alex

[TheShabz]

1. Sounds like you're using Outlook. I have run into that problem as well and found that unless you turn that security feature off globally for all users on that exchange server, its not happening. I'm trying to use Gmail and CDO to send the emails.

2. look up Outlook's sendOnBehalfOf. that might be your solution. If you go the smtp (gmail) route, just make a rule that will send those emails to a folder you dont care about. delete the messages in it every now and then.

[Gargen]

This is what i'm using now...

DoCmd.SendObject acSendTable, "Employees", acFormatXLS, _ "Nancy Davolio; Andrew Fuller", "Joan Weber", , _ "Current Spreadsheet of Employees", , False I need to make it so that they do not know who sent the email. This is out of MS Access

[TheShabz]

you will need more control over the email than the sendObject will provide. i just stumbled across this link. check it out and let me know how it goes. I may use it as well. it's supposed to bypass the outlook security warning. you could change the "from" info in it as well.

http://www.everythingaccess.com/tuto...curity-Warning

[Gargen]

wow, that website is complicated. it's gotta be easier than that.

[TheShabz]

it is if you dont mind the warning that comes up every time you want to send a message. bypassing a security feature is a complicated process.