Macro for Auto Mail from excel, with espect to a target date

**V.G.PADMANABHAN** · 07-09-2013, 03:38 AM

Dear Friends,

Can any one help me for my below requirement,

I am preparing a Minutes of the Meeting in XL 2007,
I want a macro which has to send a mail (I am using Microsoft Outlook mail) to the mail id in column ‘F’ with the subject mentioned in the column ‘G’, if the status of column ‘H’ is ‘Inprogress’.
No mail should be sent if the status of column ‘H’ is ‘Completed’. Please check the attached xl sheet, which will clearly explain you my requirement.

Please support me. Thanks in advance.

**humdingaling** · 07-09-2013, 03:48 AM

what do you want in the body of email?

**humdingaling** · 07-09-2013, 03:56 AM

co-incidentally was working on outlook macro so had it ready, made some adjustments for your needs
the send command is stopped for debugging purposes
delete the ' in your final macro to enable autosend

see attached

**EDIT
need to amend the TO: field to be

Please Login or Register  to view this content.

was picking up RESP in spreadsheet

**V.G.PADMANABHAN** · 07-09-2013, 04:13 AM

Thanks for your responce
The body of the mail should have "One of your action has reached the target date, Pls. do the needful at the earliest".

**humdingaling** · 07-09-2013, 04:23 AM

blah read your description other way round
i made it only email if completed

Please Login or Register  to view this content.

amended code with your subject

**V.G.PADMANABHAN** · 07-09-2013, 04:31 AM

Boss,

I tried modified what you said, but it is not working.

Not getting any mail generated.

Pls. support. Thanks.

**humdingaling** · 07-09-2013, 08:52 AM

Missing top line
Sub EmailVBA()

**V.G.PADMANABHAN** · 07-11-2013, 06:22 AM

Thanks Boss,

Working fine.

**humdingaling** · 07-11-2013, 07:39 PM

not a problem

If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Thanks