Email different reports to different emails with one click

[bass_twitch]

Happy to help.

Got another one for you all now,

Whenever access tries to send the emails, outlook wants my permission for each and every email sent. (i.e. I have to click 'allow'), is there any code that can automaticalyl either bypass or 'allow' each email without human interface inbetween each one?

Thanks

 

[raghuprabhu]

Hi bass twich,

Please look at my sample. It creates the reports in txt files instead of pdf.

Hope this helps..

http://www.access-programmers.co.uk/forums/showthread.php?t=217439

Cheers
Raghu Prabhu
Melbourne, Oz

 

[pbaldy]

Options to avoid the Outlook warning messages include using CDO to send the mail, a free utility called ClickYes, and Outlook Redemption. Personally I'd use CDO.