Sending an email on workbook save
 

HI,
I have a work logging spreadsheet that allows me to keep track of
outstanding items.
The assignee of the tasks are chosen using a static drop down list
(data validation)

I'm hoping for an automated email to be sent to the persion I assign a
task to, containing the contents of several cells (and a standard
subject line)
Is this possible?

can anyone give me any tips/advice/code?

thanks in advance,
Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=501974

Sending an email on workbook save
 

Take a look at www.rondebruin.nl/sendmail.htm

--

HTH

RP

"matpj" wrote in
message ...

HI,
I have a work logging spreadsheet that allows me to keep track of
outstanding items.
The assignee of the tasks are chosen using a static drop down list
(data validation)

I'm hoping for an automated email to be sent to the persion I assign a
task to, containing the contents of several cells (and a standard
subject line)
Is this possible?

can anyone give me any tips/advice/code?

thanks in advance,
Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile:
http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=501974

Sending an email on workbook save
 

This is a broad brush at the syntax to send e-mails. You have to firs
load the Outlook library, and can then use all the commands o
Outlook.


Set OutlookApp = Outlook.Application
Set MItem = OutlookApp.CreateItem(olMailItem)
With MItem
.To = "e-mail address" (or cell reference)
.Subject = "Hot Line pivots are updated" (or cell reference)
Msg = "Hot Line pivots are updated" & vbCrLf (or cel
reference)
Msg = Msg & "next line" .Body = Msg
.Send
End Wit

--
besbau
-----------------------------------------------------------------------
besbaum's Profile: http://www.excelforum.com/member.php...fo&userid=2520
View this thread: http://www.excelforum.com/showthread.php?threadid=50197

Sending an email on workbook save
 

thanks for the response, guys.
I use Notes here.
is there a Notes library that you are aware of?


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=501974

Sending an email on workbook save
 

Hi

See
http://www.rondebruin.nl/mail/links.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"matpj" wrote in message
...

thanks for the response, guys.
I use Notes here.
is there a Notes library that you are aware of?


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=501974

Sending an email on workbook save
 

thanks fo the links.
I've successfully adapted the code to send Notes email.

my new problem is trying figure out how to make it include only NEW
items in the email.

Typically when I open the spreadsheet, i'll add a work item at the
bottom, and assign the resource.
when I assign the resource (or possibly when I save or exit the work
log) I need the email to be created only with any new items for that
person.

any good ideas?
I could create a new worksheet with the new work item reference in A1,
then each other new item I add will be inserted in the cell below.

On worksheet exit this could be erased.
then my email item could look at the new worksheet as a range.

although i'm not sure what action I would use to get Excel to copy the
work item on to the new worksheet.. (i'm thinking out loud here!)

alternatively, I create an Access form, that I enter the details in.
On the save button this item is then apended to my work log AND an
email is sent out.

any suggestions (the simpler the better!)


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=501974