I am using VBA to automatically send emails with Outlook. I am surprised that the VBA takes about 10 seconds for each email.
Exceprts from my code are below. Is there anyway to speed this up?
![]()
Please Login or Register to view this content.
I am using VBA to automatically send emails with Outlook. I am surprised that the VBA takes about 10 seconds for each email.
Exceprts from my code are below. Is there anyway to speed this up?
![]()
Please Login or Register to view this content.
Hi Larry,
My guess is that at least 5 seconds of the 10 is used by the warning that an application is trying to send e-mail on your behalf. Not sure what the other 5 would be.
I used the following code and it ran in about 6 seconds (including the 5 second warning, for which I have an app that auto-clicks YES after it becomes active).
![]()
Please Login or Register to view this content.
Out of curiosity, how long does the code take without Attachments ?
(I am presuming MyOutlookVariable to be a Global variable somewhere ?)
We might also need to see the code being used to invoke the mail call...
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks