Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing 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 wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@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 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 koul@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.com 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 works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh +91-9177-444-840, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Ashish Koul Visit http://www.excelvbamacros.com/ http://www.accessvbamacros.com/ P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hey, I'm on break for exam n doesn't have access to my PC/Lalptop. I'll be able to see in to this not before sun eve or monday. If sum one can help then would be great!! Cheerz Thanks::Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: Jayaprakash S bhat.jayaprak...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 9 Nov 2012 11:03:17 To: excel-macros@googlegroups.com 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 but fails when data linked to application)... the Data what i'm talking about is linked to application and it will get refreshed each second (Refer Yahoo-finance for more info on how the data keeps changin in each seconds). With your current code, it is sending e-mail on every refresh without validating the Value condition (Using If condition to get an Value in the enclosed file). Can you help me with Validating option ?? Cheers JP. On Thu, Nov 8, 2012 at 5:03 PM, VBA VABZ v...@vabs.in wrote: hi Happy to know that things are working after so much of struggle by you guyz. Add in teh begining Dim Fname as variant Before with statement add this line FName = ActiveWorkbook.Path \ ActiveWorkbook.Name Between with statement add this line .Attachments.Add FName Cheerz//Vabs On Thu, Nov 8, 2012 at 4:46 PM, veerendra vanam veerendra.va...@gmail.com wrote: Dear Sir, It's working fine but i need attached file also where give path adreess in that macro code On Wed, Nov 7, 2012 at 7:08 PM, Vabz v...@vabs.in wrote: Hi Veerendra PFA this is designed to send email every 30secs. You can change linez to send evry hours Cheers//Vabs On Tuesday, November 6, 2012 6:00:55 PM UTC+5:30, Vabz wrote: Hi Send file with your code. Rgds//Vabs On Tuesday, November 6, 2012 5:55:23 PM UTC+5:30, Jayaprakash S wrote: Hi Vabz, Nope, not giving the desired result... (attached the sample required file for more info) A) THIS PIVOT WILL GET AUTO REFRESHED (BASED ON GIVEN TIMINGS) B) ANY CHANGES IN THE TOTAL SHOULD SEND E-MAIL @ ONLY ONCE ( EXMPL: REFRESHED @ 9 :00 AM FOUND RAM : 200 AND AGAIN REFRESHED @ 9.20 AM AND OUND RAM : 200 - THEN, MAIL TO BE SENT @ 9: AM BUT NOT @ 9.20 AM) C) E-MAIL SHOULD BE OF AUTO GENERATED ONE WHICH IS BASED ON PIVOT VALUES (TO SEND E-MAIL I SHOULD NOT RUN ANY MACROS OR PRESS ANY BUTTON - AS AND WHEN PIVOT REFRESHES BASED ON ITS VALUE, IT SHOULD SHOOT AN AUTO GENERATED E-MAIL. thank you. JP. On Tue, Nov 6, 2012 at 5:20 PM, Vabz v...@vabs.in wrote: Hi I have just tested it workz..Pl update me form your end!! Rgds//Vabs On Tuesday, November 6, 2012 5:15:26 PM UTC+5:30, Vabz wrote: Hi Ignore earlier consider this Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName '.DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub On Tuesday, November 6, 2012 5:11:56 PM UTC+5:30, Vabz wrote: Hi Try this: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub This wll sent email every ten minutes Rgds//vabs On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S wrote: Dear Vabs, Thank you very much for spending your valuable time on my query... It is not giving me the required output... as it fails when : say for example : a) Refreshed @ 9.00 AM Data found as : 0 b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2 c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2 in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM E-mail to be sent and @ 9:20 AM again No E-mail as no change in the Value (also e-mail has already been sent @ 9.10 AM !!) Thank you. JP On Tue, Nov 6, 2012
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi Vabs, Sorry Was on leave... I do not have any codes, so what ever you had given, i tried with it and it is asking me to run the macro for sending e-mails... Instead i want the codes : When Pivot gets refreshed, Macro should run automatically and send an e-mail if there is any change in the Pivot Value (explained with an example in my previous attachement) any possibility of helping me ?? Thanks in advance! Cheers JP. On Tue, Nov 6, 2012 at 6:00 PM, Vabz v...@vabs.in wrote: Hi Send file with your code. Rgds//Vabs On Tuesday, November 6, 2012 5:55:23 PM UTC+5:30, Jayaprakash S wrote: Hi Vabz, Nope, not giving the desired result... (attached the sample required file for more info) A) THIS PIVOT WILL GET AUTO REFRESHED (BASED ON GIVEN TIMINGS) B) ANY CHANGES IN THE TOTAL SHOULD SEND E-MAIL @ ONLY ONCE ( EXMPL: REFRESHED @ 9 :00 AM FOUND RAM : 200 AND AGAIN REFRESHED @ 9.20 AM AND OUND RAM : 200 - THEN, MAIL TO BE SENT @ 9: AM BUT NOT @ 9.20 AM) C) E-MAIL SHOULD BE OF AUTO GENERATED ONE WHICH IS BASED ON PIVOT VALUES (TO SEND E-MAIL I SHOULD NOT RUN ANY MACROS OR PRESS ANY BUTTON - AS AND WHEN PIVOT REFRESHES BASED ON ITS VALUE, IT SHOULD SHOOT AN AUTO GENERATED E-MAIL. thank you. JP. On Tue, Nov 6, 2012 at 5:20 PM, Vabz v...@vabs.in wrote: Hi I have just tested it workz..Pl update me form your end!! Rgds//Vabs On Tuesday, November 6, 2012 5:15:26 PM UTC+5:30, Vabz wrote: Hi Ignore earlier consider this Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName '.DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub On Tuesday, November 6, 2012 5:11:56 PM UTC+5:30, Vabz wrote: Hi Try this: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub This wll sent email every ten minutes Rgds//vabs On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S wrote: Dear Vabs, Thank you very much for spending your valuable time on my query... It is not giving me the required output... as it fails when : say for example : a) Refreshed @ 9.00 AM Data found as : 0 b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2 c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2 in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM E-mail to be sent and @ 9:20 AM again No E-mail 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, Vabz v...@vabs.in wrote: Hi This will help you: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing 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 wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@googlegroups.com Subject: Re: $$Excel-Macros$$ Send mail from
Fwd: $$Excel-Macros$$ Send mail from outlook Every One Hr .
*Dear Ashish* * * *There are 3 customers : a, b c.* * * Dist active passive total a 26 20 46 b 45 78 123 c 25 25 50 *It means all are having different e-mail id's, and the particular figures are to be sent only to specific customer only, then how we can send it in a single click.* * * *Please inform. Thanks,* * * *Regards* *Pravin Gunjal.** * -- Forwarded message -- From: ashish koul koul.ash...@gmail.com Date: Mon, Nov 5, 2012 at 10:43 PM Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr . To: excel-macros@googlegroups.com check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerendra.va...@gmail.comwrote: 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 works in vba,,, plz find attachment of sample file -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi This will help you: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing 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 wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com javascript: wrote: ** Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone -- *From: * veerendra vanam veerend...@gmail.com javascript: *Sender: * excel-...@googlegroups.com javascript: *Date: *Mon, 5 Nov 2012 22:50:04 +0530 *To: *excel-...@googlegroups.com javascript: *ReplyTo: * excel-...@googlegroups.com javascript: *Subject: *Re: $$Excel-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 koul@gmail.comjavascript: wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.comjavascript: 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 works in vba,,, plz find attachment of sample file -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Dear Vabs, Thank you very much for spending your valuable time on my query... It is not giving me the required output... as it fails when : say for example : a) Refreshed @ 9.00 AM Data found as : 0 b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2 c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2 in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM E-mail to be sent and @ 9:20 AM again No E-mail 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, Vabz v...@vabs.in wrote: Hi This will help you: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing 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 wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@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 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 koul@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.com 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 works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh +91-9177-444-840, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Ashish Koul Visit http://www.excelvbamacros.com/ http://www.accessvbamacros.com/ P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi Try this: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As StringApplication.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:15:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S wrote: Dear Vabs, Thank you very much for spending your valuable time on my query... It is not giving me the required output... as it fails when : say for example : a) Refreshed @ 9.00 AM Data found as : 0 b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2 c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2 in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM E-mail to be sent and @ 9:20 AM again No E-mail 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, Vabz v...@vabs.in javascript: wrote: Hi This will help you: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in javascript: .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing 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 wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@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 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 koul@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.com 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 works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh +91-9177-444-840, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Ashish Koul Visit
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi Ignore earlier consider this Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As StringApplication.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName '.DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub On Tuesday, November 6, 2012 5:11:56 PM UTC+5:30, Vabz wrote: Hi Try this: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As StringApplication.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub This wll sent email every ten minutes Rgds//vabs On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S wrote: Dear Vabs, Thank you very much for spending your valuable time on my query... It is not giving me the required output... as it fails when : say for example : a) Refreshed @ 9.00 AM Data found as : 0 b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2 c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2 in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM E-mail to be sent and @ 9:20 AM again No E-mail 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, Vabz v...@vabs.in wrote: Hi This will help you: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing 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 wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@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 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 koul@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.com 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 works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh +91-9177-444-840, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi I have just tested it workz..Pl update me form your end!! Rgds//Vabs On Tuesday, November 6, 2012 5:15:26 PM UTC+5:30, Vabz wrote: Hi Ignore earlier consider this Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As StringApplication.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName '.DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub On Tuesday, November 6, 2012 5:11:56 PM UTC+5:30, Vabz wrote: Hi Try this: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As StringApplication.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub This wll sent email every ten minutes Rgds//vabs On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S wrote: Dear Vabs, Thank you very much for spending your valuable time on my query... It is not giving me the required output... as it fails when : say for example : a) Refreshed @ 9.00 AM Data found as : 0 b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2 c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2 in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM E-mail to be sent and @ 9:20 AM again No E-mail 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, Vabz v...@vabs.in wrote: Hi This will help you: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing 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 wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@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 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 koul@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.com 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 works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh +91-9177-444-840, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi Vabz, Nope, not giving the desired result... (attached the sample required file for more info) A) THIS PIVOT WILL GET AUTO REFRESHED (BASED ON GIVEN TIMINGS) B) ANY CHANGES IN THE TOTAL SHOULD SEND E-MAIL @ ONLY ONCE ( EXMPL: REFRESHED @ 9 :00 AM FOUND RAM : 200 AND AGAIN REFRESHED @ 9.20 AM AND OUND RAM : 200 - THEN, MAIL TO BE SENT @ 9: AM BUT NOT @ 9.20 AM) C) E-MAIL SHOULD BE OF AUTO GENERATED ONE WHICH IS BASED ON PIVOT VALUES (TO SEND E-MAIL I SHOULD NOT RUN ANY MACROS OR PRESS ANY BUTTON - AS AND WHEN PIVOT REFRESHES BASED ON ITS VALUE, IT SHOULD SHOOT AN AUTO GENERATED E-MAIL. thank you. JP. On Tue, Nov 6, 2012 at 5:20 PM, Vabz v...@vabs.in wrote: Hi I have just tested it workz..Pl update me form your end!! Rgds//Vabs On Tuesday, November 6, 2012 5:15:26 PM UTC+5:30, Vabz wrote: Hi Ignore earlier consider this Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName '.DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub On Tuesday, November 6, 2012 5:11:56 PM UTC+5:30, Vabz wrote: Hi Try this: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub This wll sent email every ten minutes Rgds//vabs On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S wrote: Dear Vabs, Thank you very much for spending your valuable time on my query... It is not giving me the required output... as it fails when : say for example : a) Refreshed @ 9.00 AM Data found as : 0 b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2 c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2 in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM E-mail to be sent and @ 9:20 AM again No E-mail 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, Vabz v...@vabs.in wrote: Hi This will help you: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing 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 wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@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 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 koul@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerend...@gmail.com 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 works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi Send file with your code. Rgds//Vabs On Tuesday, November 6, 2012 5:55:23 PM UTC+5:30, Jayaprakash S wrote: Hi Vabz, Nope, not giving the desired result... (attached the sample required file for more info) A) THIS PIVOT WILL GET AUTO REFRESHED (BASED ON GIVEN TIMINGS) B) ANY CHANGES IN THE TOTAL SHOULD SEND E-MAIL @ ONLY ONCE ( EXMPL: REFRESHED @ 9 :00 AM FOUND RAM : 200 AND AGAIN REFRESHED @ 9.20 AM AND OUND RAM : 200 - THEN, MAIL TO BE SENT @ 9: AM BUT NOT @ 9.20 AM) C) E-MAIL SHOULD BE OF AUTO GENERATED ONE WHICH IS BASED ON PIVOT VALUES (TO SEND E-MAIL I SHOULD NOT RUN ANY MACROS OR PRESS ANY BUTTON - AS AND WHEN PIVOT REFRESHES BASED ON ITS VALUE, IT SHOULD SHOOT AN AUTO GENERATED E-MAIL. thank you. JP. On Tue, Nov 6, 2012 at 5:20 PM, Vabz v...@vabs.in javascript: wrote: Hi I have just tested it workz..Pl update me form your end!! Rgds//Vabs On Tuesday, November 6, 2012 5:15:26 PM UTC+5:30, Vabz wrote: Hi Ignore earlier consider this Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in javascript: .CC = .Subject = Test .Body = Test .Attachments.add FName '.DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub On Tuesday, November 6, 2012 5:11:56 PM UTC+5:30, Vabz wrote: Hi Try this: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Application.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in javascript: .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Application.OnTime Now + TimeValue(00:10:00), email Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing Set otlNSpace = Nothing End Sub This wll sent email every ten minutes Rgds//vabs On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S wrote: Dear Vabs, Thank you very much for spending your valuable time on my query... It is not giving me the required output... as it fails when : say for example : a) Refreshed @ 9.00 AM Data found as : 0 b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2 c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2 in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM E-mail to be sent and @ 9:20 AM again No E-mail 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, Vabz v...@vabs.in wrote: Hi This will help you: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject(Outlook.Application) Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path \ ActiveWorkbook.NAME With otlNewMail .To = v...@vabs.in .CC = .Subject = Test .Body = Test .Attachments.add FName .DeferredDeliveryTime = Range(A1) .Send End With Set otlNewMail = Nothing Set otlApp = Nothing Set otlAttach = Nothing Set otlMess = Nothing 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 wrote: Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerend...@gmail.com Sender: excel-...@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-...@googlegroups.com ReplyTo: excel-...@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 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 koul@gmail.com wrote: check
$$Excel-Macros$$ Send mail from outlook Every One Hr .
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 works in vba,,, plz find attachment of sample file -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Update data.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerendra.va...@gmail.comwrote: 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 works in vba,,, plz find attachment of sample file -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. send email.xlsm Description: Binary data
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone -Original Message- From: veerendra vanam veerendra.va...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 To: excel-macros@googlegroups.com Reply-To: 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 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 koul.ash...@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerendra.va...@gmail.com 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 works in vba,,, plz find attachment of sample file -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul.ash...@gmail.com wrote: ** Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone -- *From: * veerendra vanam veerendra.va...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Mon, 5 Nov 2012 22:50:04 +0530 *To: *excel-macros@googlegroups.com *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 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 koul.ash...@gmail.comwrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerendra.va...@gmail.com 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 works in vba,,, plz find attachment of sample file -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
If you have the macro able to run by a button, check the documentation for the OnTime function. this should allow you to set it up to run at specific times. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: veerendra vanam veerendra.va...@gmail.com To: excel-macros@googlegroups.com Sent: Mon, November 5, 2012 12:25:26 PM Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr . Dear Sir, i need automatic send with attachment how its possible any one need help me,,, On Mon, Nov 5, 2012 at 10:49 PM, koul.ash...@gmail.com wrote: Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone From: veerendra vanam veerendra.va...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 5 Nov 2012 22:50:04 +0530 To: excel-macros@googlegroups.com 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 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 koul.ash...@gmail.com wrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerendra.va...@gmail.com 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 works in vba,,, plz find attachment of sample file -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh +91-9177-444-840, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Ashish Koul Visit http://www.excelvbamacros.com/ http://www.accessvbamacros.com/ PBefore printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh
Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
dear sir i need send attachment also pls send vba code for attachment,, On Mon, Nov 5, 2012 at 10:49 PM, koul.ash...@gmail.com wrote: ** Right now its manual effort . You need to click on button every hour Sent on my BlackBerry® from Vodafone -- *From: * veerendra vanam veerendra.va...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Mon, 5 Nov 2012 22:50:04 +0530 *To: *excel-macros@googlegroups.com *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 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 koul.ash...@gmail.comwrote: check the attachment see if it helps On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam veerendra.va...@gmail.com 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 works in vba,,, plz find attachment of sample file -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *ThanksRegards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical Contractors *H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,* * Hyderabad-500072,-Andhra Pradesh +91-9177-444-840*, -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum