.sendmail code not sending mail

[donkey_uk]

Hi

I have created a travel request form with a small macro to send mail from refrenced cells and a subject line.

When i click on send it open up my emails and all is grat but when i click send mail i get errors, saying email address is wrong here is the code could someone have a look please.

I have also attached the file.

Please Login or Register  to view this content.

New Travel Request in Excel.xlsx

[donkey_uk]

Anyone help me on this please. Thanks you

[Naveed Raza]

Using Outlook u want to send Mail ?

[donkey_uk]

Lotus notes and outlook

[Naveed Raza]

Replace your code with below one

Please Login or Register  to view this content.

[donkey_uk]

Replace your code with below one

Please Login or Register  to view this content.

Hi thank you .

I have tryed this useing lotus nots all good, but when its used in outlook i get errors

It wont send the email unless i manulay put a ; at then end of the last email address.

I have tryed to put this in the code but wont work.

Any ideas ?

Thank you

[donkey_uk]

If I only have 1 email addy in it will work . But I need 3. It's stage that it work on lotus notes but not outlook. Any ideas ?

[donkey_uk]

Anyone one ?

[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]

Thank you so much that worked.

[Naveed Raza]

Thank you so much that worked.

Glad to Help
Please Mark the thread as SOLVED & Click on * Add Reputation to say thanks.