email VBA/MACRO

  • Thread starter Thread starter skylinekiller
  • Start date Start date
S

skylinekiller

On my worksheet I have a column which turns colors when the trainin
date gets within 90 days, 30 days, and over 90 days. My question is,
was wondering if it's possible that once that cell falls with in the 9
days before training I want Excel to automatically send out an email
to the person who is due training and the trainer.
If this is possible, can you please tell me exactly what I need t
change to change who the email will go to?
For example, I when John Souza has any one of his training fall unde
90 days, I want an email sent to (e-mail address removed) & (e-mail address removed)
For Jane Doe, I would like an email sent to (e-mail address removed)
(e-mail address removed)
Etc…. If there are any extra columns that are required, I would lik
to hide them only for the finished Project.
I also have to worksheets on the same file, I would like the same o
the other, but would like to know how to correctly copy the macros o
what ever the process is? Thank you for your time and effort

Attachment filename: training help.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=53067
 
Thank you Ron, I Didn't quite figure it out yet, but I'm still trying.

As for the other post, what was that for. Am I not suppose to attac
my excel file? Why do they have that option in this forum if it i
against the rules? I'm new so I don't know the norm in this forum.
hope I get this figured out, I hae been reading e-books and just kee
coming up short
 
Hi skylinekiller

You posted from ExcelForum.com
You can attach files there.

Most people read this thread on the MS public newsgroup.
The rules in the public groups are in the link I posted.
 
Ron, can you take a look at my file and tell me why the emails don'
automatically send to the names after lines are skipped and why the
don't send on the other worksheet? EXACTLY how can I fix it? Usin
Excel 200
 
From your last post on your other thread:

I was trying to use the code that you made. It appeared to work, bu
when I skipped lines to seperate the names and training, it wouldn'
run the macro. If I want to add another email address, can I just ad
it below in column "B"? How can I change what email address it send
to? Are columns H & I needed? I appreciate you time effort an
knowledge spent on helping me. Thank you.

And in answer to your questions:

The e-mail address used is found from Column B. You can just chang
it/add more etc as you wish but the named range used will have to b
expanded.

H & I are used to check if a mail has been sent prevously- you migh
not open the spreadsheet with exactly 90 days to go so the code run
for anything under 90 days and checks if these cells have been give
values. If they have, no mail is sent.

Aplogies for my silence in helping with this, I have been away the ban
holiday weekend.

Dunca
 
Back
Top