| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-Mail from Excel at a Certain Specified Time
I am using Ron De Bruin's excellent code to e-mail various files from
Excel, however is the feature available whereby I can specify within the code a delayed time the mail should be sent at. Just like I can specify the Importance, Read receipt etc If I was to do this in outlook I'd choose Options - Do Not Deliver Before etc. So I just wish to include this feature within the code by specifying a date and Time. Thus I still run my Macro but my mail will remain in Outlooks Outbox until the given time and date. BTW, my date and Time would be values within a sheet, say Sheet2 A1 Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
E-Mail from Excel at a Certain Specified Time
Not 100% sure but i think Outlook has the ability to have code put in it and
if so, I am sure you could get it to read the date/time in the sheet specified. "Sean" wrote in message oups.com... I am using Ron De Bruin's excellent code to e-mail various files from Excel, however is the feature available whereby I can specify within the code a delayed time the mail should be sent at. Just like I can specify the Importance, Read receipt etc If I was to do this in outlook I'd choose Options - Do Not Deliver Before etc. So I just wish to include this feature within the code by specifying a date and Time. Thus I still run my Macro but my mail will remain in Outlooks Outbox until the given time and date. BTW, my date and Time would be values within a sheet, say Sheet2 A1 Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
E-Mail from Excel at a Certain Specified Time
Hi Sean
You can try ..DeferredDeliveryTime never us it but something like this .DeferredDeliveryTime = DateAdd("h", 1, Now) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sean" wrote in message oups.com... I am using Ron De Bruin's excellent code to e-mail various files from Excel, however is the feature available whereby I can specify within the code a delayed time the mail should be sent at. Just like I can specify the Importance, Read receipt etc If I was to do this in outlook I'd choose Options - Do Not Deliver Before etc. So I just wish to include this feature within the code by specifying a date and Time. Thus I still run my Macro but my mail will remain in Outlooks Outbox until the given time and date. BTW, my date and Time would be values within a sheet, say Sheet2 A1 Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
E-Mail from Excel at a Certain Specified Time
Thanks Ron
Not much look, wasn't sure of the syntax but I tried these two and both shot the mail out straight off ..DeferredDeliveryTime = DateAdd("16:50", 1, Now) ..DeferredDeliveryTime = DateAdd("h", 1, "16:50") Ron de Bruin wrote: Hi Sean You can try .DeferredDeliveryTime never us it but something like this .DeferredDeliveryTime = DateAdd("h", 1, Now) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sean" wrote in message oups.com... I am using Ron De Bruin's excellent code to e-mail various files from Excel, however is the feature available whereby I can specify within the code a delayed time the mail should be sent at. Just like I can specify the Importance, Read receipt etc If I was to do this in outlook I'd choose Options - Do Not Deliver Before etc. So I just wish to include this feature within the code by specifying a date and Time. Thus I still run my Macro but my mail will remain in Outlooks Outbox until the given time and date. BTW, my date and Time would be values within a sheet, say Sheet2 A1 Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
E-Mail from Excel at a Certain Specified Time
I test it this this evening Sean
First time for me also -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sean" wrote in message oups.com... Thanks Ron Not much look, wasn't sure of the syntax but I tried these two and both shot the mail out straight off .DeferredDeliveryTime = DateAdd("16:50", 1, Now) .DeferredDeliveryTime = DateAdd("h", 1, "16:50") Ron de Bruin wrote: Hi Sean You can try .DeferredDeliveryTime never us it but something like this .DeferredDeliveryTime = DateAdd("h", 1, Now) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sean" wrote in message oups.com... I am using Ron De Bruin's excellent code to e-mail various files from Excel, however is the feature available whereby I can specify within the code a delayed time the mail should be sent at. Just like I can specify the Importance, Read receipt etc If I was to do this in outlook I'd choose Options - Do Not Deliver Before etc. So I just wish to include this feature within the code by specifying a date and Time. Thus I still run my Macro but my mail will remain in Outlooks Outbox until the given time and date. BTW, my date and Time would be values within a sheet, say Sheet2 A1 Thanks |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
E-Mail from Excel at a Certain Specified Time
Hi Sean
This is working Ok on my machine .DeferredDeliveryTime = DateAdd("n", 3, Now) It wait for 3 minuts in the outbox before it go out -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... I test it this this evening Sean First time for me also -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sean" wrote in message oups.com... Thanks Ron Not much look, wasn't sure of the syntax but I tried these two and both shot the mail out straight off .DeferredDeliveryTime = DateAdd("16:50", 1, Now) .DeferredDeliveryTime = DateAdd("h", 1, "16:50") Ron de Bruin wrote: Hi Sean You can try .DeferredDeliveryTime never us it but something like this .DeferredDeliveryTime = DateAdd("h", 1, Now) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sean" wrote in message oups.com... I am using Ron De Bruin's excellent code to e-mail various files from Excel, however is the feature available whereby I can specify within the code a delayed time the mail should be sent at. Just like I can specify the Importance, Read receipt etc If I was to do this in outlook I'd choose Options - Do Not Deliver Before etc. So I just wish to include this feature within the code by specifying a date and Time. Thus I still run my Macro but my mail will remain in Outlooks Outbox until the given time and date. BTW, my date and Time would be values within a sheet, say Sheet2 A1 Thanks |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
E-Mail from Excel at a Certain Specified Time
Thanks Ron
If however I wanted to send at a specified date and time, rather than x mins after I actually run my code Ron de Bruin wrote: Hi Sean This is working Ok on my machine .DeferredDeliveryTime = DateAdd("n", 3, Now) It wait for 3 minuts in the outbox before it go out -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... I test it this this evening Sean First time for me also -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sean" wrote in message oups.com... Thanks Ron Not much look, wasn't sure of the syntax but I tried these two and both shot the mail out straight off .DeferredDeliveryTime = DateAdd("16:50", 1, Now) .DeferredDeliveryTime = DateAdd("h", 1, "16:50") Ron de Bruin wrote: Hi Sean You can try .DeferredDeliveryTime never us it but something like this .DeferredDeliveryTime = DateAdd("h", 1, Now) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sean" wrote in message oups.com... I am using Ron De Bruin's excellent code to e-mail various files from Excel, however is the feature available whereby I can specify within the code a delayed time the mail should be sent at. Just like I can specify the Importance, Read receipt etc If I was to do this in outlook I'd choose Options - Do Not Deliver Before etc. So I just wish to include this feature within the code by specifying a date and Time. Thus I still run my Macro but my mail will remain in Outlooks Outbox until the given time and date. BTW, my date and Time would be values within a sheet, say Sheet2 A1 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I do an e-mail mail merge using an Excel spreadsheet? | Excel Worksheet Functions | |||
| Importing dates and military time from Excel into word doc mail me | Excel Discussion (Misc queries) | |||
| General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) | |||
| I have to repeat my password for e-mail every time, how do i get . | Excel Discussion (Misc queries) | |||
Hybrid Mode
