E-Mail Using Excel VBA & Outlook Error

[NeedForExcel]

Hi,

I have set up a code to send E-mail using Outlook & Excel VBA. The Code is as below -

Please Login or Register  to view this content.

The Code Runs OK the 1st time, however during the second time it gives me the following error -

Run-time error '462': The remote server machine does not exist or is unavailable

Can anyone guide me how I can get rid of this?

Helpful Links -

http://support.microsoft.com/kb/189618

http://support.microsoft.com/kb/178510

[BrianM45]

Hi

The correct code is

Please Login or Register  to view this content.

A+

[NeedForExcel]

Hi!

Thank you for the reply.

However, the code ran for the 1st time well.. After that I am again getting error.

Error - Runtime Error 2147023170 (800706be): Automation Error TheRemoteProcedureCallFailed

Unable to figure out why.

Can you please help?

Cheers,

Deep

[pareshj]

Hi msexcelathome,

I think excel address referencing is the issue(reference to Excel has been created and has not been released).

Try to change your code:

Like

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

And,

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

And check similar lines of code. Hope this will help you.



Regards,
Paresh J

[NeedForExcel]

Hi!

I figured it out on my own somehow.

Thank you for the help anyway..

Reputation Added!