Sender: excel-macros@googlegroups.com
Date: Fri, 9 Nov 2012 11:03:17
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi Vabz,
Here with enclosing the file with VBA script which i'm currently using
(it is working for manual stuff
6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S
>>>>> >>> wrote:
>>>>> >>>>
>>>>> >>>> Dear Vabs,
>>>>> >>>>
>>>>> >>>> Thank you very much for spen
as no change in the Value
>> >>>> (also e-mail has already been sent @ 9.10 AM !!)
>> >>>>
>> >>>> Thank you.
>> >>>>
>> >>>> JP
>> >>>>
>> >>>> On Tue, Nov 6, 2012 at 4:13 PM,
rote:
> >>>> > Hi
> >>>> >
> >>>> > This will help you:
> >>>> >
> >>>> > Sub email()
> >>>> > Dim myOutlook As Object
> >>>> > Dim myMailItem As Object
> >>&g
ect
>>>> > Dim FName As String
>>>> > Set otlApp = CreateObject("Outlook.Application")
>>>> > Set otlNewMail = otlApp.CreateItem(olMailItem)
>>>> > FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.NAME
>&g
> .Attachments.add FName
>>> > .DeferredDeliveryTime = Range("A1")
>>> > .Send
>>> > End With
>>> >
>>> > Set otlNewMail = Nothing
>>> > Set otlApp = Nothing
>>> > Set otlAttach = Noth
thing
>> > Set otlNSpace = Nothing
>> > End Sub
>> >
>> >
>> > Where in you have to customise range A1 to give next delivery time.
>> >
>> > Rgds//Vabs
>> >
>> > On Monday, November 5, 2012 10:54:30 PM UTC+5:30, veerendra vanam
>> i need automatic & send with attachment how its possible
> any
> >> one need help me,,,
> >>
> >>
> >> On Mon, Nov 5, 2012 at 10:49 PM, wrote:
> >>>
> >>> Right now its manual effort . You need to cl
utton every hour
>>> Sent on my BlackBerry® from Vodafone
>>>
>>> From: veerendra vanam
>>> Sender: excel-...@googlegroups.com
>>> Date: Mon, 5 Nov 2012 22:50:04 +0530
>>> To:
>>> ReplyTo: excel-...@googleg
m >
>> *Sender: * excel-...@googlegroups.com
>> *Date: *Mon, 5 Nov 2012 22:50:04 +0530
>> *To: *>
>> *ReplyTo: * excel-...@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
>>
>> Thanks for reply in this code wh
veerendra vanam
> *Sender: * excel-macros@googlegroups.com
> *Date: *Mon, 5 Nov 2012 22:50:04 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
>
> Thanks for reply in this code when i am run the macro e
Sent on my BlackBerry® from Vodafone
>From: veerendra vanam
>Sender: excel-macros@googlegroups.com
>Date: Mon, 5 Nov 2012 22:50:04 +0530
>To:
>ReplyTo: excel-macros@googlegroups.com
>Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One
from Vodafone
> --
> *From: * veerendra vanam
> *Sender: * excel-macros@googlegroups.com
> *Date: *Mon, 5 Nov 2012 22:50:04 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
>
> Thanks
-Macros$$ Send mail from outlook Every One Hr .
Thanks for reply in this code when i am run the macro every 1 hr send
automatically or we click the button every 1 hrplz tell me,,
On Mon, Nov 5, 2012 at 10:43 PM, ashish koul wrote:
> check the attachment see if it helps
>
>
> On Mon,
Thanks for reply in this code when i am run the macro every 1 hr send
automatically or we click the button every 1 hrplz tell me,,
On Mon, Nov 5, 2012 at 10:43 PM, ashish koul wrote:
> check the attachment see if it helps
>
>
> On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam <
> veerendra.
check the attachment see if it helps
On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam
wrote:
> Dear team
>
> i have data file in E drive i send mail to every 1 hr
> update mail.summary sheet in body ,,mail send every update every 1 hr
> 24hrs,365 days any macro from this type of wo
16 matches
Mail list logo
