I know a lot about excel but I know nothing about VBA or Macros (literally nothing).
I am trying to set up an excel sheet that will automatically send a notification email when the due date is approaching.
I've found a couple of threads about this but I just don't seem to get it.
Here's my excel. I want to set up email notifications for the Acknowledgement, 8D, and Closure sections.
Please help!
Attachment 347918CRMT.xlsm
Thanks in advance,
Sarah
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Unfortunately this doesn't help me because I don't want to send an attachment. I want my email to just send a notification "Complaint # 123456 is due today" or something to that effect.
I found this thread which I think does what I need to do but I don't know how to integrate into my excel workbook.
http://www.excelforum.com/excel-prog...rom-excel.html
Just omit the attachment line then.
Ok wonderfulthat works.
How do I make it automatic?
Can I have it choose the email based on a cell reference?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks