Need Macro to Send email

Microsoft Excel 2003 (full product)
June 7, 2010 at 03:44:22
Specs: Windows XP
Hello all,

I have used Excel for years, and run macros, but never written one myself.

I have a spreadsheet of archived items that I need to review on a weekly basis to ensure boxes get sent back in a timely manner.

The relevant columns are:

Box number (an 8 digit number)
Date recalled
Recalled by (this will be a name)
Date sent back (date - if not sent back, this will be empty)
Review date (this will have a date 9 working days after the date the box was recalled)

My ideal scenario is that I open the s/sheet each week, run my macro which will:

Check the Date sent back box, if it is populated - nothing happens
If it is empty, the macro then checks the Review date box and if the present date is beyond the review date - the macro forms and email to be sent to the name in the Recalled by box stating:

Subject: Box number: (it gets this from the Box number column)

Please note this box was recalled on DD/MM/YY and is still in the office.

Please advise if this can now be sent back - if not please respond accordingly.

This is a big ask, I realise this - and I don't necessarily want someone to do this for me - I ideally want to understand how I do this, so that I can do it going forward myself.

Any help would be greatly appreciated!



See More: Need Macro to Send email

Report •

June 7, 2010 at 06:05:00
I'm not an expert on macros by any means, but the few times I've
done basic ones it's been okay after a bit of trial & error. There
are a couple of good websites that give mini tutorials on how to
create basic macros, these may be enough for your needs. Put
'writing excel macros' into Google & look at the first couple of

"I've always been mad, I know I've been mad, like the most of us..."

Report •

June 7, 2010 at 09:30:50

Look at this post, response 7 and
this post.

Both create and send e-mails from Excel.

Note the warnings about the use of passwords in the code and potential security risks - less of an issue if you are not distributing the worksheet to anyone else.

Have a go with the concepts in these posts and post back if you need more specific advice.


Report •

Related Solutions

Ask Question