Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * *

2012-12-27 Thread Hilary Lomotey
Hi This is really cool I like it very much but I have realised that when you have another excel book opened andd assuming you dont know the password and the you click on exit excel will ask you whether you want to close all tabs when you click on cancel it will.allow the user access to the

Re: $$Excel-Macros$$ Data collection - Problem *

2012-12-27 Thread respuzy
Hi your requirement Ȋ̝̊̅§ not too clear. What do you want to copy and where do you want it pasted. Can you explain a bit more. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Bhaity Koneng bhaity.kon...@gmail.com Sender: excel-macros@googlegroups.com Date:

$$Excel-Macros$$ Re: Data collection - Problem

2012-12-27 Thread Prince
Hi Bhaity Koneng, * * *Can you Please explain your problem bit more as it is not clear to us to understand your exact requirment. * * * *Prince *On Thursday, December 27, 2012 1:18:37 PM UTC+5:30, Bhaity Koneng wrote: Hi experts, it is my first post and here i have attached a excel

$$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to customers using VBA

2012-12-27 Thread bpascal123
Is anyone also aware that the op wants to send dunning letters? I understand dunning letter are printed paper sent through regular post with stamps and in some case with a receipt. That would make the answer for this query complete. Regards, happy new year to every one On Wednesday, December

$$Excel-Macros$$ splitting the column

2012-12-27 Thread Rajesh Agarwal
Dear Sir I want to split column a into column b and c according to their heading with formula. How to do that. Thanks Rgds -- *Rajesh Kumar Agarwal* *9811063001* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ splitting the column

2012-12-27 Thread NOORAIN ANSARI
Dear Rajesh, see attachment, Hope it will help to you. On Thu, Dec 27, 2012 at 4:40 PM, Rajesh Agarwal rajey...@gmail.com wrote: Dear Sir I want to split column a into column b and c according to their heading with formula. How to do that. Thanks Rgds -- *Rajesh Kumar Agarwal*

$$Excel-Macros$$ Re: splitting the column

2012-12-27 Thread Prince
Hi Rajesh, Please Apply : =RIGHT(A2,11) in Cell C2 and drag Down up to last Row =SUBSTITUTE(A2,C2,) in Cell B2 and drag Down up to last Row Note: But first write formula in Cell C2 :) Regards Prince On Thursday, December 27, 2012 4:40:50 PM UTC+5:30, rajeyssh wrote: Dear Sir I want to

$$Excel-Macros$$ Hi

2012-12-27 Thread rajat arora
Hi I would like to be part of this group..request you to please add below ID rajat198...@yahoo.com Regards Rajat -- 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,

Re: $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to customers using VBA

2012-12-27 Thread Subu S
Dunning letter = Are these Printed forms where numbers were filled manually ?? Answer =  Manual forms and snail mail was approx 15+ years so , NOT now  Dunning or reminder is done thru E mail now   -- Regards Subu mail_to_s...@yahoo.com From: bpascal123

Re: $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to customers using VBA

2012-12-27 Thread Subu S
Dear Pascal Thanks for the responses. I am reply each response separately so as not to confuse other readers I can NOT use Paper mail /  snail mail or postal mail as you mail call it  Unfortunately postal mail is NOT fast enough, takes many days to reach (customers at) other places, and IF

Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to customers using VBA

2012-12-27 Thread Subu S
Dear Pascal Thanks.  you saidchange the yellow line to     Dim olApp As Object     Set olApp = CreateObject(Outlook.Application)* or add a reference to Microsoft Outlook 9.0 Object Library from Tools - Reference // First I add(ed) a reference to Microsoft

$$Excel-Macros$$ Re: Better way of producing scenario results.....

2012-12-27 Thread PJB41
Thanks Anoop. This is part of the solution but what I really wanted was for all the results for A,B,C,D on the results sheet to update automatically following any changes on the calc sheet i.e. the calc sheet explicitly shows the calculations for one set of data but the results sheets so the

Re: $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to customers using VBA

2012-12-27 Thread bpascal123
I agree I was confused about your requirement. I'm currently working as an AR accountant / credit-controller and in many cases, a postal letter sent with a receipt (a receipt is the proof the postman has either handed the letter to the recipient or if the recipient is not present when the post

Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to customers using VBA

2012-12-27 Thread bpascal123
Hi Subu I haven't tried the entire code, I just helped you figure out how to link outlook to excel using the concept of early late binding with vba. Internet search engines tell plenty of things about that. From resources I can access, tried to run Sub CheckBindingLB() Dim olApp As

Re: $$Excel-Macros$$ Hi

2012-12-27 Thread NOORAIN ANSARI
Dear Rajat, You have been added successfully in excel-macros group, Please check and confirm. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http://

Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to customers using VBA

2012-12-27 Thread mail_to_subu
Gentlemenbr/br/br/I really appreciate both of you trying to help mebr/br/Let me wait for Anoop's reply br/br/I am very confident that the end result is something that will help me and also help many others trying to send automated / format letters over e

Re: $$Excel-Macros$$ Data collection - Problem

2012-12-27 Thread Bhaity Koneng
Dear All Experts, Gud mrng..!! any Solution for this ? Thanks Regards, Koneng On Thu, Dec 27, 2012 at 2:42 PM, Bhaity Koneng bhaity.kon...@gmail.comwrote: Hi Hilary / Prince Sir, In the excel sheet, if you see in sheet2, then NH No, Name of the section...and Car

$$Excel-Macros$$ AUTO: Sharon Hutchison is out of the office (returning 07/01/2013)

2012-12-27 Thread Sharon Hutchison
I am out of the office until 07/01/2013. Any queries please contact Nicky Minchella Note: This is an automated response to your message $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 18 Messages in 8 Topics sent on 28/12/2012 12:45:16 AM. This is the only notification you will

Re: $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to customers using VBA

2012-12-27 Thread mail_to_subu
Dear pascal br/br/br/My rule : br/===br/br/1. bad / terrible customer - proof ... Signature ... Etcbr/br/2. Most normal customers and even late payers but honest payers : email. Fast gets the job done without fussbr/br/Also please note that e commerce legislation is improving by

Re: $$Excel-Macros$$ Data collection - Problem

2012-12-27 Thread Lalit Mohan Pandey
Hi Koneng, Explaing with steps would be more understandable. Regards, Lalit Mohan On Friday, 28 December 2012 09:36:24 UTC+5:30, Bhaity Koneng wrote: Dear All Experts, Gud mrng..!! any Solution for this ? Thanks Regards, Koneng On Thu, Dec 27, 2012 at 2:42 PM,

Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to customers using VBA

2012-12-27 Thread Excel_Lover
Hi Subu, See if the below link will help you, http://www.rondebruin.nl/sendmail.htm Regards, Faisal. On Fri, Dec 28, 2012 at 7:06 AM, mail_to_s...@yahoo.com wrote: Gentlemen I really appreciate both of you trying to help me Let me wait for Anoop's reply I am very confident that the