Outllok is timimg out when sending e-mail from access database

I

Icmeler

I have a macro set up in access to e-mail reports in excel format.
I have just upgraded to XP and Microsoft Outlook keeps timing out when the
macr is running.
Does anyone know how to increase the time allowed?
Thanks
 
A

Arvin Meyer

Icmeler said:
I have a macro set up in access to e-mail reports in excel format.
I have just upgraded to XP and Microsoft Outlook keeps timing out when the
macr is running.
Does anyone know how to increase the time allowed?
Thanks
Click to expand...

Windows is event driven and code events from Office are sequential. It
shouldn't time out. Try writing your macro as VBA code (Hint: look at
"SendObject" in help) or at the sample code on my website. Which will email
from Outlook without timing out:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
I

Icmeler

Thankyou for your reply.
Unfortunately I know little about Visual basics and am unsure how to set
this up.
Is there any easy way of doing it?
Thankyou
 
Top