Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-generate OUTLOOK email based upon EXCEL Workbook data
I've always been told, "It never hurts to ask", so here I go.
I was wondering if it is possible (without Papal Intervention) to use Excel to generate email via MS Outlook based upon worksheet data. Specifically: I'm working on a task to record/track/inventory Purchase Orders (PO) on my contract. My desire is to send email 120 days before the PO ends to the individual(s) on the contract exercising authority over the purchased items or services. [Email addresses of cognizant individuals and renewal data info would be entered when the PO is approved and received, thus setting the stage for renewal evolutions in the future.] I'm not well-skilled by any means in Excel, but would prefer to use it if possible to accomplish all that is required of me. Thanks, Jeff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-generate OUTLOOK email based upon EXCEL Workbook data
Hi Jeff
You can start with the second example on this page http://www.rondebruin.nl/mail/folder3/message.htm Start with a simple test workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Henn9660" wrote in message ... I've always been told, "It never hurts to ask", so here I go. I was wondering if it is possible (without Papal Intervention) to use Excel to generate email via MS Outlook based upon worksheet data. Specifically: I'm working on a task to record/track/inventory Purchase Orders (PO) on my contract. My desire is to send email 120 days before the PO ends to the individual(s) on the contract exercising authority over the purchased items or services. [Email addresses of cognizant individuals and renewal data info would be entered when the PO is approved and received, thus setting the stage for renewal evolutions in the future.] I'm not well-skilled by any means in Excel, but would prefer to use it if possible to accomplish all that is required of me. Thanks, Jeff |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-generate OUTLOOK email based upon EXCEL Workbook data
Your ears must be burning! I just printed out your, "Example Code for
sending mail from Excel" (updated 22-Feb-2008). Sadly, however, I lost the link from which I printed it! LOL. But come next Monday morning (when my brain is again working...), I'll go back and locate it in order to capture the add-ins you referenced. Thanks for such a quick reply, Ron! It's greatly apreciated. Jeff "Ron de Bruin" wrote: Hi Jeff You can start with the second example on this page http://www.rondebruin.nl/mail/folder3/message.htm Start with a simple test workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Henn9660" wrote in message ... I've always been told, "It never hurts to ask", so here I go. I was wondering if it is possible (without Papal Intervention) to use Excel to generate email via MS Outlook based upon worksheet data. Specifically: I'm working on a task to record/track/inventory Purchase Orders (PO) on my contract. My desire is to send email 120 days before the PO ends to the individual(s) on the contract exercising authority over the purchased items or services. [Email addresses of cognizant individuals and renewal data info would be entered when the PO is approved and received, thus setting the stage for renewal evolutions in the future.] I'm not well-skilled by any means in Excel, but would prefer to use it if possible to accomplish all that is required of me. Thanks, Jeff |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-generate OUTLOOK email based upon EXCEL Workbook data
Good luck
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Henn9660" wrote in message ... Your ears must be burning! I just printed out your, "Example Code for sending mail from Excel" (updated 22-Feb-2008). Sadly, however, I lost the link from which I printed it! LOL. But come next Monday morning (when my brain is again working...), I'll go back and locate it in order to capture the add-ins you referenced. Thanks for such a quick reply, Ron! It's greatly apreciated. Jeff "Ron de Bruin" wrote: Hi Jeff You can start with the second example on this page http://www.rondebruin.nl/mail/folder3/message.htm Start with a simple test workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Henn9660" wrote in message ... I've always been told, "It never hurts to ask", so here I go. I was wondering if it is possible (without Papal Intervention) to use Excel to generate email via MS Outlook based upon worksheet data. Specifically: I'm working on a task to record/track/inventory Purchase Orders (PO) on my contract. My desire is to send email 120 days before the PO ends to the individual(s) on the contract exercising authority over the purchased items or services. [Email addresses of cognizant individuals and renewal data info would be entered when the PO is approved and received, thus setting the stage for renewal evolutions in the future.] I'm not well-skilled by any means in Excel, but would prefer to use it if possible to accomplish all that is required of me. Thanks, Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to email Excel workbook through MS Outlook | Excel Discussion (Misc queries) | |||
Auto sending workbook or sheet as an attachment using Outlook | Excel Discussion (Misc queries) | |||
How do I email two pages of an excel workbook in Outlook 2003 | Excel Discussion (Misc queries) | |||
Auto generate email | Excel Discussion (Misc queries) | |||
How do move folders from web based email account to outlook? | Excel Discussion (Misc queries) |