email from Excel

[C Holmes]

I have a data base set up in Excel where products expire on a certain date. This is indicated by a "rule function" Is it possible to set Excel up so when a product expires Excel will generate an email and send it indicating that a or a particular product has expired? I know that seems out there but this program seems to be able to do anything and everything. Any help would be greatly appreciated.

[dominicb]

Good afternoon C Holmes

It can. Sort of.
It can't e-mail itself, but it can send e-mail through your default e-mail client (I should add most clients, some easier than others). However you need to be aware that this is quite advanced stuff. I would suggest you have a look at Ron de Bruin's pages and decide if you want to code your own looking at some of his examples, or whether to cut out all the hard work and make use of his free e-mailing add-in.

http://www.rondebruin.nl/sendmail.htm
http://www.rondebruin.nl/mail/add-in.htm

HTH

DominicB

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I've edited it this time,but make sure that you read the Forum Rules before posting again

[C Holmes]

I have downloaded the email add on and of course I get a warning of enableing this type of file. Is this a reliable file, no worries?

[C Holmes]

It reports that I do not have Outlook installed (which I Do not) I am using Novell Groupwise. Is there anyway to change it to using Groupwise?

[C Holmes]

Well it does not work, How can I remove it?

[Domski]

Don't know if it's any help but there's some code here that will allow you to send email through Groupwise:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=277

Afraid I've no experience of Groupwise so doubt can be much more help.

Dom

[royUK]

Remove an excel addin

[C Holmes]

So does the Groupwise VBA send the whole workbook or just an email?

[Domski]

The code looks like it creates an email and has an option to attach a file to it.

If it was the workbook containing the code that you wanted to attach to the email have a look at the VBA SaveCopyAs method. You could use this to save a copy of the file onto the C: drive, attach it to the email and then use the Kill statement to delete the copy of the file.

Dom