When sending an object through an Access database with Outlook 2003 it requires a person to say yes to sending, otherwise it will sit there and do nothing. Is there a way around this so that this portion of the macro can be automated? We have a scheduler that has always sent certain reports out, but ever since we had 2003 installed we have to send them out manually. Any thoughts?
TJAC, This is a security setting in Outlook, and not really related to anything with Access or your macro. I have heard of people having success with ClickYes http://www.contextmagic.com/ -- Steve Schapel, Microsoft Access MVP TJAC wrote: > When sending an object through an Access database with Outlook 2003 it > requires a person to say yes to sending, otherwise it will sit there and do > nothing. Is there a way around this so that this portion of the macro can be > automated? We have a scheduler that has always sent certain reports out, but > ever since we had 2003 installed we have to send them out manually. > Any thoughts?
