Re: $$Excel-Macros$$ Re: Need a Email Macro based on the Cell time

2012-06-06 Thread Puttu *
most of the timings set only 8 hours window. It will create any unnecessary problem It would be great some one come with macro work on this. On Thu, Jun 7, 2012 at 3:07 AM, netuser1110 wrote: > Leaving Outlook + high speed Internet connection open 24/24, you put > yourself at risk sending Buy V

$$Excel-Macros$$ Re: Need a Email Macro based on the Cell time

2012-06-06 Thread netuser1110
Leaving Outlook + high speed Internet connection open 24/24, you put yourself at risk sending Buy Viagra spams or any other less or more serious risks! On Wednesday, June 6, 2012 11:48:03 AM UTC+1, bpascal123 wrote: > > I'm trying to figure out something related to Vba instead of a new > script

$$Excel-Macros$$ Re: Need a Email Macro based on the Cell time

2012-06-06 Thread bpascal123
I'm trying to figure out something related to Vba instead of a new scripting language. I'm thinking about running a Vba script from Outlook. Outlook will open the workbook and pick the time from there and set itself to send emails... or better each time the workbook is updated (I broadly unders

$$Excel-Macros$$ Re: Need a Email Macro based on the Cell time

2012-06-06 Thread bpascal123
Hi, The last idea as I still don't know how much the email client matters, I presume Puttu is using Outlook by default. As he doesn't specify it maybe the email client client doesn't matter, then it's just a question of sending email no matter the email domain name. In this case, the idea woul

Re: $$Excel-Macros$$ Re: Need a Email Macro based on the Cell time

2012-06-06 Thread David Grugeon
This idea is likely to cause a lot of problems. Mainly because the workbook will have to be kept open all the time. There are two possible approaches. One is to have a macro which, each minute, scans the spreadsheet to find times between Now and Now + 1 Minute. Then it would send the email if i

$$Excel-Macros$$ Re: Need a Email Macro based on the Cell time

2012-06-05 Thread bpascal123
Hi Puttu, Please provide more details about your task such as the email client you want to use. I would suppose Outlook but you don't tell. How column F is completed? Do you manually changed the dates? What are the dates related to. You should provide more details, it's too vague to me and mayb