$$Excel-Macros$$ Mass mailer help!!!

2014-09-02 Thread Jones George
Hi All, I need an urgent help. I have to send a mass mailer to approx 10k email addresses. The task at hand is that I have to filter these email addresses before I send the mailer. I have to remove unwanted email addresses such as @yahoo.com, @gmail.com, @rediffmail.com, @mtnl.com, etc. Since the

Re: $$Excel-Macros$$ Mass mailer help!!!

2014-09-02 Thread Anil Gawli
Dear Jones, Pls share the worksheet with us, we'll do it as much we can do it.. Warm Regards, Gawli Anil :) On Tue, Sep 2, 2014 at 2:05 PM, Jones George wrote: > Hi All, > > I need an urgent help. I have to send a mass mailer to approx 10k email > addresses. The task at hand is that I have to

Re: $$Excel-Macros$$ Mass mailer help!!!

2014-09-02 Thread Vaibhav Joshi
How do you want to bypass domain name, want to amend existing code than post the same! If you want to segregate in excel file then share excel file format. Cheers!! On Tue, Sep 2, 2014 at 2:05 PM, Jones George wrote: > Hi All, > > I need an urgent help. I have to send a mass mailer to appro

$$Excel-Macros$$ Mass mailer help!!!

2014-09-02 Thread Jones George
Thanks Anil for replying. However I cannot share the worksheet as its Confidential information. Is it possible to prepare a sample list of email addresses and then prepare a macro. I know im asking too much. But need help. Regards Jones George On 2 Sep 2014 15:04, "Jones George" wrote: > Thank

Re: $$Excel-Macros$$ Mass mailer help!!!

2014-09-02 Thread Vaibhav Joshi
Hi Chek this... Everything is self explanatory. Cheers!! On Tue, Sep 2, 2014 at 3:10 PM, Jones George wrote: > Thanks Anil for replying. However I cannot share the worksheet as its > Confidential information. > > Is it possible to prepare a sample list of email addresses and then > prepare a

$$Excel-Macros$$ Auto filter issue

2014-09-02 Thread Sunil Kumar Yadav
Hi Friends, Please guide me on my second query​ ​ I have recorded macro on auto filter and modified the 2 conditions but when "GPRS" not found against "5", in this situation filter fills "correct" in all row of status column, i want to set such condition when "GPRS" not found against "5" then proc

Re: $$Excel-Macros$$ Need Help - Show (-) Value

2014-09-02 Thread Ashu k
Dear Sir, Thanks to all of you. Specially thanks to Ashish Sir. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

Re: $$Excel-Macros$$ Need Help - Show (-) Value

2014-09-02 Thread Vaibhav Joshi
Yes, cheers to Ashish Bro!! On Tue, Sep 2, 2014 at 6:54 PM, Ashu k wrote: > Dear Sir, > > Thanks to all of you. > > Specially thanks to Ashish Sir. > > > > Regards > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official F

Re: $$Excel-Macros$$ Need Help - Show (-) Value

2014-09-02 Thread Ashish Kumar
Welcome Ashu. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Plea

Re: $$Excel-Macros$$ Need Help - Show (-) Value

2014-09-02 Thread Ashish Kumar
Thanks Vaibhav Bro. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, U

Re: $$Excel-Macros$$ Need Help - Show (-) Value

2014-09-02 Thread Ashu k
Dear Sir, If i want this output in Below column till last in A column, B column and C column. Is it possible to create this kind of function. please help. Regards Ashu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook pag

Re: $$Excel-Macros$$ Macro Stop start (pause) Timer

2014-09-02 Thread Vaibhav Joshi
you need to break macro in 3 part.. At the end of 1st Macro add line.. Application.OnTime Now + TimeValue("00:00:20"), "Macro2" so after 20 seconds it will run Macro2. At the end of 2nd Macro add line.. Application.OnTime Now + TimeValue("00:00:20"), "Macro3" so after 20 seconds it will run Mac

Re: $$Excel-Macros$$ Auto filter issue

2014-09-02 Thread Vaibhav Joshi
share sample book & explain step by step what you want to do.. Cheers!! On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav wrote: > > Hi Friends, > > Please guide me on my second query​ > ​ > I have recorded macro on auto filter and modified the 2 conditions but > when "GPRS" not found against

$$Excel-Macros$$ Jr. Java Developers required $35\hr

2014-09-02 Thread Umesh IT Rec
Greetings One of our client is looking for multiple Jr. Java Developer for upgrade of their existing Applications, in NJ. Modernizing multiple legacy applications. Location: Trenton, NJ Duration 12+ mths Positions: 20 (State Project) Skills required: Knowledge of Core Java is an essenti

$$Excel-Macros$$ Need macro to covert pdf to excel

2014-09-02 Thread Ujjwal Desai
Hello guys, Still awaiting for your response. Ujjwal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. P

$$Excel-Macros$$ modify a macro to have startCol and endCol

2014-09-02 Thread Mr_Bill
I currently have a macro that works for columns 1:5 I would like to know how would I make the script work with columns 7:11 with 10 being the sortKeyCol. Not sure what I need to change in the code itself to make it work. Could someone lend a hand with this please. Here is a stripped down ver

Re: $$Excel-Macros$$ modify a macro to have startCol and endCol

2014-09-02 Thread Pramod Singh
Hi Bill Please find the attached file . P On Wed, Sep 3, 2014 at 1:17 AM, Mr_Bill wrote: > I currently have a macro that works for columns 1:5 > > I would like to know how would I make the script work with columns 7:11 > with 10 being the sortKeyCol. > > Not sure what I need to chang

Re: $$Excel-Macros$$ Need macro to covert pdf to excel

2014-09-02 Thread Pramod Singh
Hi Ujjwal. Please find the below links for your requirement. http://www.myengineeringworld.net/2013/03/vba-macro-to-convert-pdf-files-into.html P On Tue, Sep 2, 2014 at 10:58 PM, Ujjwal Desai wrote: > Hello guys, > > Still awaiting for your response. > > Ujjwal > > -- > Are you =EXP(E:R

Re: $$Excel-Macros$$ modify a macro to have startCol and endCol

2014-09-02 Thread Mr_Bill
I appreciate the effort but that doesnt work correctly. On Tuesday, September 2, 2014 8:52:50 PM UTC-7, pramodb35 wrote: > > Hi Bill > > Please find the attached file . > > > P > > > On Wed, Sep 3, 2014 at 1:17 AM, Mr_Bill > > wrote: > >> I currently have a macro that works for columns 1:

Re: $$Excel-Macros$$ modify a macro to have startCol and endCol

2014-09-02 Thread Pramod Singh
Hi Bill PFA... On Wed, Sep 3, 2014 at 10:55 AM, Mr_Bill wrote: > I appreciate the effort but that doesnt work correctly. > > > On Tuesday, September 2, 2014 8:52:50 PM UTC-7, pramodb35 wrote: > >> Hi Bill >> >> Please find the attached fi

RE: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell in calculation

2014-09-02 Thread Nitin Balodi
Hi Vaibhav, Thanks for the idea. It works. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Mon, 1 Sep 2014 20:27:03 +0530 Subject: Re: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell in calculation To: excel-macros@googlegroups.com Hi check this, if you change v

Re: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell in calculation

2014-09-02 Thread Vaibhav Joshi
Great!! Cheers! On Wed, Sep 3, 2014 at 12:01 PM, Nitin Balodi wrote: > Hi Vaibhav, > > Thanks for the idea. It works. > > > Regards. > > Yours Sincerely, > *Nitin Balodi* > > > -- > From: v...@vabs.in > Date: Mon, 1 Sep 2014 20:27:03 +0530 > > Subject: Re: $$Excel-Ma