Slow Email (Outlook) only if email needs input (not auto send)

[gangel]

Hi again.



Every time i get something running another issue comes up!! SOOO CLOSE!

lol

So I got my email system running.

I use the email object not the sendobject (Set oEmailItem = oOutlook.CreateItem(olMailItem))

BUT i have tried this with both methods!

I get the email up and type in the email address (outlook) then press send.

The 'windows thinking' icon comes up over the mouse pointer and it takes about 15-20 secs to email the item.

If i use the Outlook.Createitem and just put the address as oemailItem.TO = hello at google dot com Then i can send about 30 emails in a second using exactly the same report in a loop...

I'm getting an error 0 with no text when it finishes running and it DOES send the email, but i dont get why it sits there and thinks for so long first!

Any ideas? or directions i can look and read?

[ItsMe]

There are dozens of ways to approach this. My preference is to use early binding and make as many declarations as possible. This goes with Automation of most any application, Outlook, Excel, Acrobat, etc. Here is a code snippet that may be useful to you. I mention early binding and declarations because this tells the PC to reserve a specific amount of RAM prior to executing the code that will use the RAM. Otherwise, the procedure may cause the PC to reserve an unnecessary amount of memory.

https://www.accessforums.net/import-...tml#post281258


.

[gangel]

wow thats great. worked a treat.

Now just to send some kind of naming criteria over from the report so that the naming of the exported file is dynamic.

This is a function that runs off a right click "send email" custom shortcut.

[ItsMe]

Cool, sounds like you have it covered. Let us know if you hit a roadblock or something was not clearly explained.

[gangel]

thanks again.

I do have it covered, but i dont totally understand WHY this works better.?

Is it.. because you attached it early before the actual event, then the program knows how much memory to allocate to Outlook when it opens?

[ItsMe]

I have not seen your code so I cannot explain why your code was causing a slowdown of your system. It is common to use late binding and to use variables that are larger (require a lot of memory) than they need to be.

When possible, you want to use the New keyword in your declarations. Also, you want to explicitly declare the type. When you choose a type, your choice should be one that best fits the situation. You do not want everything to be Object when you need Application or MailItem.

In short, Access does not have to guess what type to use and this is where the optimization occurs.

'Reference Microsoft Outlook and
'use early binding
Dim objOutlook As New Outlook.Application
Dim objNewEmail As MailItem
Dim objAttachReport As Attachments

'Instantiate your objects
Set objNewEmail = objOutlook.CreateItem(olMailItem)
Set objAttachReport = objNewEmail.Attachments