Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending Workbook to an email address. | Excel Discussion (Misc queries) | |||
Sending an email from Excel attaching the workbook they are in | Excel Programming | |||
Sending 1 worksheet of a workbook as email file attachment | Excel Discussion (Misc queries) | |||
Sending email WITHOUT attaching a workbook? | Excel Programming | |||
sending a workbook by email to multiple recipients | Excel Programming |