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