Please help me with my first major Outlook VBA routine

[newboy18]

Please help, I have written my first major VBA routine to send emails with attachments to customers, but for every one of the 150 emails being sent Outlook pops up with the message “A program is trying to send mail using Item.Send”. I can click Yes but not 150 times, and with a 5 second delay on every one.
What can I do, please don’t tell me that I have wasted the past 2 weeks?
Is there an option I can turn off, is there a “Yes to all” option / button, is there a registry fix like the one for Outlook attachments?

 

[robcarr]

Newboy18,

Is the coding within Outlook or are using another program, if you use Excel to send to people you can bypass the security prompt,(win NT, Outlook 2000) I am not sure how to by pass it in Outlook though.

Rob.

Thanks Rob.

 

[newboy18]

Hi,
The routine is written in Access XP, I have found a utility called Express ClickYes, it works buy automaticaly clicking on the Yes box but it still has to wait 5 seconds for each email.