Not recieving email fro VBA code

[donkey_uk]

Hi

I'm having problems with a code to send email from VBA, it opens up ok on my outlook and then I click on send and all seems ok, but I never reactive the email back and no one els gets the email. can anyone help

Please Login or Register  to view this content.

[Leith Ross]

Hello donkey_uk,

As a rule, you should never add code statements that turn off error handling or displaying alerts until your code is fully debugged.

Try this version of you code and see if there are any error messages or alerts that popup.

Please Login or Register  to view this content.

[donkey_uk]

Hi

Thank you, I have tried your code any nothing pops up, no errors, it send the email but I get nothing back

[donkey_uk]

it seems to be stuck on sending the email

[Theglobe]

Try replacing .Display with .send

Please Login or Register  to view this content.

[donkey_uk]

Hi


nope Im still having the same problem, outlook seems to be stuck on the sendin mail bit, doing my head in now lol.

Is there any other code I can use ?

[Naveed Raza]

try this one

Please Login or Register  to view this content.

[donkey_uk]

try this one

Please Login or Register  to view this content.

Nope same proble.

Just been tols the person im sending to uses AOL will this make a diffrence to the code ?

As i have no problems sending it to hi and i use Lotus Notes..

If there is what code should i use for AOL

Thank you

[donkey_uk]

Sorry for confusion as I was told he was using Outlook. So need code for AOL.
Thank you

[Theglobe]

Ok, try looking on Ron De Bruin, he has a lot of god tips for excel.

[Naveed Raza]

Hi,

Replace your complete code with below one

Note: Run Mail_Call macro only

Please Login or Register  to view this content.

[donkey_uk]

Hi,

Replace your complete code with below one

Note: Run Mail_Call macro only

Please Login or Register  to view this content.

Thank you this worked.

Could i ask one thing thou.

On the msg box that pops up saying Yes or No. can you change this to say " Send to United " & " Send to EGE" could you put a cancle button there too plase.

Thank you

[Pepe Le Mokko]

Pehaps this link might help

There is also code available at http://www.rondebruin.nl/win/section1.htm

[donkey_uk]

Hi,

Replace your complete code with below one

Note: Run Mail_Call macro only

Please Login or Register  to view this content.

This code all worked , but 1 small problem when I click on send mail it opens up outlook ans sends the mail but outlook closes and email not sent.

I have to reopen outlook so it sends the email. is there anyway that outlook will remain open until the email has sent or just keep it open ?

Thank you

[donkey_uk]

Anyone ? Almost ther now just this one little snag

[D0se]

If your mails are getting stuck in the outbox then u only need to be sure the outlook application is open before u run the code.
I had similar issue and adding

Please Login or Register  to view this content.

before the outmail line fixed the problem.
Should look like this:

Please Login or Register  to view this content.

[donkey_uk]

If your mails are getting stuck in the outbox then u only need to be sure the outlook application is open before u run the code.
I had similar issue and adding

Please Login or Register  to view this content.

before the outmail line fixed the problem.
Should look like this:

Please Login or Register  to view this content.

Hey thanx bud it worked, I so love you lol.

Thanx again

[D0se]

yw, just mark as solved if you can please

[john55]

Hi,
I used yr code with the outlook closed, the code opens it, I hit "send" and I rcvd it, hope you rcvd it too, I used yr email adddrtresses.

[Pepe Le Mokko]

Have you compared with Ron's code?