Re: E-Mail from Excel at a Certain Specified Time

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ron many thanks for your interest

I have another piece of your code which I use to e-mail except I've one
slight problem and don't understand why its happening. The code below
is supposed to CC those addresses in cell AH3, it does except it also
includes an address in the CC field that is in AH2. I don't fully
undersatnd the code, but apart from above it works great

For Each cell In ThisWorkbook.Sheets("E-Figures") _
.Range("AH3:AH3").Cells.SpecialCells(xlCellTypeConstants)
If cell.Value Like "?*@?*.?*" Then
strto = strto & cell.Value & ";"
End If
Next
strto = Left(strto, Len(strto) - 1)


Ron de Bruin wrote:

to send at a specified date and time
I will see if this is possible tomorrow


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sean" <seanryanie@xxxxxxxxxxx> wrote in message news:1168031068.619125.5410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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" <rondebruin@xxxxxxxxxxxx> wrote in message news:%239vVqqOMHHA.448@xxxxxxxxxxxxxxxxxxxxxxx
I test it this this evening Sean
First time for me also

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sean" <seanryanie@xxxxxxxxxxx> wrote in message news:1168015732.623427.247910@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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" <seanryanie@xxxxxxxxxxx> wrote in message news:1167988998.436115.298900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: E-Mail from Excel at a Certain Specified Time
    ... I use your strto to populate the CC field ctually. ... Ron de Bruin wrote: ... however is the feature available whereby I can specify within ...
    (microsoft.public.excel.programming)
  • Re: Creating Individual Excel Files from Sheets
    ... > First I take a cup of coffee with my wife and children. ... > Regards Ron de Bruin ... >> allow the user to browse to a file of his choice, specify a destination of ...
    (microsoft.public.excel.misc)
  • Re: E-Mail from Excel at a Certain Specified Time
    ... Ron de Bruin wrote: ... .DeferredDeliveryTime = DateAdd ... however is the feature available whereby I can specify within ...
    (microsoft.public.excel.programming)
  • Re: Creating Individual Excel Files from Sheets
    ... > Dear Ron: ... > I would love to produce a module that would bring up a dialog that would> allow the user to browse to a file of his choice, specify a destination of> his choice, and then run this code on the workbook so specified and save the> individual files in the location specified. ... >> Dim wb As Workbook ...
    (microsoft.public.excel.misc)
  • Re: E-Mail from Excel at a Certain Specified Time
    ... Ron, just popped it on to the address on your web site. ... Ron de Bruin wrote: ... The Address I want to populate the To field is in AH2. ... however is the feature available whereby I can specify within ...
    (microsoft.public.excel.programming)