Reg: Excel file autosending email using Microsoft Outlook

[abhimails]

Hi All,

I am new to VBA and trying to learn the nitty-gritty of excel vba. My query is that I am trying to send an email automatically from my excel sheet through outlook 2007 application. It is a simple macro which checks for the condition for the first cell in row while using two other cell in the same row as email id and message bidy. The issue that I am facing is the loop which according to me is pretty simple but still it is giving the error "The object has been moved/deleted" while executing and sending the email successfully for the first cell in the range (Cells_M).

Please Login or Register  to view this content.

[abhimails]

Fotis, Can you please let people post their answers or solutions in this post and remove your message... I am new to this forum pls

[jaslake]

Hi abhimails

Welcome to the Forum!!!

I'm not able to duplicate the issue but you may wish to move the two lines of Code as indicated.

Please Login or Register  to view this content.

[abhimails]

Hurrah ! Thanks a ton buddy.. m so happy

I knew it has to be a minor change.

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.