Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send Email on Update/Close
Hello,
Some coworkers and I use an excel file to record the projects that we are working on. The file is stored in a shared folder and each of us has change access to it. My boss asked that I come up with a way to notify everyone through email when the file has been updated. I would like to use a VB (or VBA, not sure which is the proper acronym) to look at the bottom most filled cell (so if A32 was is blank/empty, it will look to A31 and so on) and email everyone in an MSOutlook distribution list with the contents of A-whatever as the subject line. To avoid confusion, though, I would like the procedure to only run when the file is updated. Anyhelp would be very appreciated. At the moment, I can prepare an email (it opens up on screen) but the file that has the macro within is set as an attachment. I would like to try and avoid this as too many copies of the file might be confusing and take up valuable email space. Thank you in advance for your help, MarcusIsFunny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
Buttons/1-add rows /2-auto save & name, close, send in email | Excel Programming | |||
How can I send an excel workbook by email for recipient to update? | Excel Discussion (Misc queries) | |||
send email with email addresses in a range of cells | Excel Programming | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) |