Macro to send email upon certain date trigger

**fabrecass** · 01-11-2013, 12:12 PM

Hi guys,

I think this is super complicated and i can't get it to work even a little bit...

i need excel to, upon opening a workbook, send an email if a condition is met, that condition being a date in a cell passing ONLY if adjacent cell is blank.

for example, in column A we have a list of dates, and if the date in A2 passes and B2 is blank, i need it to trigger an email sent to one fixed recipient, preferably with the title of the workbook within the body or title of the email.

Can someone help me?

If any more information is needed please ask!

EDIT* thinking about it, this doesn't seem like a macro is needed, perhaps an active function type thing? (forgive the lack of technical jargon)

**fabrecass** · 01-14-2013, 04:33 AM

bump

no one?

**fabrecass** · 01-14-2013, 06:20 AM

guys?! is this crazy complicated or do i smell?

**john55** · 01-14-2013, 07:14 AM

hi, try the attachement and see if it heps you!
http://www.excelforum.com/excel-gene...coming-up.html

**fabrecass** · 01-14-2013, 07:22 AM

Hi John,

thanks for the reply, and yes, it does help, is there any way to make it so that the event occurs as you open the workbook? - and i need the email to send automatically? can this be done?

**john55** · 01-14-2013, 07:25 AM

yeap, copy the whole code and paste it in Thisworkbook (have a look in the left side and click on Thisworkbook and then in the right side select Workbook
something like this...

Please Login or Register  to view this content.

**fabrecass** · 01-14-2013, 07:56 AM

Thanks for this John.

It's perfect, apart from the fact the email doesn't automatically send?

**john55** · 01-14-2013, 07:58 AM

replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

**fabrecass** · 01-14-2013, 08:11 AM

this works perfectly on the workbook you sent John, i just can't get it to work in my workbook! all i'm changing is the fact i'm using column's L and M instead of A and B...

so i amended

HTML Code:

to

HTML Code:

column M is blank yet it's not working? conditional fomatting in column M wouldn't affect it would it?

**john55** · 01-14-2013, 08:16 AM

have a look at code and replace what is reffering to column A B,C
here 1 is for col A, 2 is for col B

Please Login or Register  to view this content.

here 3 is for col C (please ignor the text in red)

Please Login or Register  to view this content.

**fabrecass** · 01-14-2013, 08:27 AM

hi john,

i've replaced 1, with 12 (for col L), 2 with 13 and i've put the email address in column N (for which i've used 14)

still no luck.

HTML Code:

**john55** · 01-14-2013, 08:32 AM

and this one for yr date, I mean L as you said...

Please Login or Register  to view this content.

**fabrecass** · 01-14-2013, 08:38 AM

yes, i've changed this one as well and still not working

!!

i wish i could upload the workbook but work restrictions won't let me!!!

**john55** · 01-14-2013, 08:42 AM

k, I try it but tell me what are your columns used, for date, for empty cell, for email address!
edit:
hope these are yr colums

Please Login or Register  to view this content.

**fabrecass** · 01-14-2013, 08:53 AM

I've got it working John! Thank you so much! however, i don't think i set out my requirements fully - even if the whole column is blank, i only want 1 email sent, currently because the whole column of M is blank it tries to send an email for each row.

does this make sense?

**john55** · 01-14-2013, 09:03 AM

if your column M is blank then

Please Login or Register  to view this content.

**fabrecass** · 01-14-2013, 10:00 AM

it keeps sending 1 email for each row, i only want 1 email sent total - not per row.

**john55** · 01-14-2013, 10:11 AM

try this, C2 is yr cell having the email address

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

**fabrecass** · 01-14-2013, 10:24 AM

not working i'm afraid, won't stop sending emails...

Please Login or Register  to view this content.

**john55** · 01-14-2013, 10:36 AM

I am sorry, maybe someone else can help you!

**fabrecass** · 01-14-2013, 10:39 AM

thanks for trying John!

can anyone else help?! If M2 is blank and the date in L2 has passed, i need to send an email.

**john55** · 01-14-2013, 10:57 AM

Please Login or Register  to view this content.

Macro to send email upon certain date trigger

LinkBack

Thread Tools

Rate This Thread

Display

Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Re: Macro to send email upon certain date trigger

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions