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

[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 login form
without entering any user name or passsword  are you able to go around and
tighten this? Thanks
On Dec 27, 2012 3:28 AM, "Lalit Mohan Pandey" 
wrote:

>  [image: Boxbe]  Automatic Cleanup: keep
> last 1 emails (mohan.pande...@gmail.com) Edit 
> rule|
>  Delete
> rule|
>  Mark
> important
>
> Hi amar
>
> Nice work . Thanks for sharing.
>
> Regards,
> Lalit Mohan
> +919711867226
>
> On Wednesday, 26 December 2012 20:09:53 UTC+5:30, (%Allmydreams%) wrote:
>>
>> Hi Guys
>>
>> check out this  you may get some more ideas to think in different
>>
>> On Sat, Dec 22, 2012 at 4:38 PM, amar takale  wrote:
>>
>>> ok,that fine no problem.
>>>
>>>
>>> On Sat, Dec 22, 2012 at 2:41 PM, Lalit Mohan Pandey <
>>> mohan.p...@gmail.com> wrote:
>>>
 Hi Amar,

 I created this file just for the way hilary wants. Now the
 specifications are changing and for that matter it is not that much 
 dynamic.

 Regards,
 Lalit Mohan


 On Saturday, 22 December 2012 12:32:37 UTC+5:30, amar takale wrote:

> Dear Lalit,
>
> but anyone can see Authorized user name.if anyone got it at least one
> authorized user name he can see also other user name.I want to hide Other
> user name or hide user Sheet if possible.
>
> Regards
> Amar
>
>  On Sat, Dec 22, 2012 at 11:24 AM, Lalit Mohan Pandey <
> mohan.p...@gmail.com> wrote:
>
>> Hi Pravin,
>>
>> You can also change the user access. Just login with Lalit Mohan and
>> add user in Authorized_User sheet.
>> Hope it will helps you.
>>
>> Regards,
>> Lalit Mohan
>>
>>
>> On Saturday, 22 December 2012 09:43:13 UTC+5:30, Pravin Gunjal wrote:
>>
>>> Hi Lalit,
>>>
>>> Can we give different passwords to access this file to authorised
>>> users..
>>>
>>> Regards
>>> Pravin Gunjal.
>>>
>>>  -- Forwarded message --
>>> From: Lalit Mohan Pandey 
>>> Date: Fri, Dec 21, 2012 at 7:26 PM
>>> Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users
>>> * * *
>>>  To: excel-...@googlegroups.com
>>> Cc: res...@gmail.com
>>>
>>>
>>>
>>> Hi Hilary,
>>>
>>> Please find the revised version of the file.
>>> User name is the same as before.
>>> Let me know if it meets your expectation.
>>>
>>> Regards,
>>> Lalit Mohan
>>>
>>> On Friday, 21 December 2012 14:54:12 UTC+5:30, hilary lomotey wrote:

 Hi Lalit

 If I don't want only the name of the user to appear once the file
 opens can you make an adjustment? Ie when the file Ȋ̝̊̅§ opened the 
 user
 name and time appears on the file name. The time Ȋ̝̊̅§ cool but then 
 every
 person can see the user name and could log in with that user name so I 
 wish
 only the name shd not appear as part of the file name. Thanks
 Sent from my BlackBerry® smartphone from Airtel Ghana
 --
 *From: *Lalit Mohan Pandey 
 *Sender: *excel-...@googlegroups.com
 *Date: *Fri, 21 Dec 2012 00:06:08 -0800 (PST)
 *To: *
 *ReplyTo: *excel-...@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ Re: Vba code to Check authorised
 users * * *

 [image: Boxbe]  This message is
 eligible for Automatic Cleanup! (mohan.p...@gmail.com) Add cleanup
 rule

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

[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 
Sender: excel-macros@googlegroups.com
Date: Thu, 27 Dec 2012 13:18:37 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Data collection - Problem *

This message is eligible for Automatic Cleanup! (bhaity.kon...@gmail.com) 
Add cleanup rule: 
https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3Dqj8lgvyJK%252BJ6snk5YrkK9Lv3A2%252FoScwqjU8duPsXODRyKLnEZfnAorFQtLYAZomjGPPeEC5zRizfgSLDdDiPBgAGfqvL%252B0SXspij0oLd%252Bi12gWfcIuiexZeQQ6Sua9Q72MWoxzAeepDQEFgnyL50NA%253D%253D%26key%3DfaGKaiGue5QmPcylpaJ91FiEHL6CSFmmILD0oK1z8S4%253D&tc=13217195517_1131430095
More info: 
http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13217195517_1131430095

-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

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

[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 which i am 
> doing manaully copy and past. and it took me time of 6 hours. i have 
> another 100 to do , i have cmpleted just only 3 and it took me 6 hours. i 
> dont know how to complete that, if i do manually it will take 4-5 months to 
> complete that. 
> Any advice or suggestions how to do this a bit quicker than me.
>  
> Thank you Gurus and please advice me some more tips to learn and have 
> ideas in excel. 
>  
>  
> Regards,
> Koneng
>

-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

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

[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 19, 2012 11:15:21 AM UTC, .. wrote:
>
> Dear List members
>
> Request : *Mail merge and E mail* using VBA or other tools 
> =
>
>- I have to send reminder / dunning letters to my customers. 
>- Unfortunately the faxing option from the company is very time 
>consuming (print, sort, fax, wait for dial tones...failure etc etc) and it 
>takes a long time. 
>- Also there isn't a corporate e mail reminder solution in sight. 
>- To avoid delays and very heavy workload, I plan to e mail the 
>reminder / dunning letters. *I have to take this personally *
>- I think this should be possible to partially automate this task 
>using XL (data) and combining that with word or VBA and send mail thru MS 
>outlook. 
>- I suspect some one may have tried this before 
>- I seek your help for innovative solutions...either VBA or any other 
>innovative solution as well . 
>- All input data would be available as XL files. Samples shown below 
>and XL files also added to this mail 
>- If this has not been tried earlier or if this is too cumbersome, 
>please drop this, ...my advance apologies .
>- Any pointers to other websites are also gratefully acknowledged 
>
>
>
> THANKS in advance !!!
>
> Subu
>
>
> My customer master looks like this  *[xl file enclosed]*
> 
>
> Customer#Customer_Name...Address..E_mail...
>
> 12345The fancy paint shopPO Box 322,
> madras...fancy_pa...@hotmail.com
> 12346Bright Colours.PO Box 123,
> cochinbright_col...@gmail.com
> 12347Best Decor Bangalore..PO Box 456,
> bangalorebest_d...@bestbangl.co.in
> and ...so on .
>
>
>
> My list of overdue invoices looks like this *[xl file enclosed] *
> ===
> Customer 
> #Invoice#...InvoiceDate.DueDateAmount_Due(Rs)
>
> 12345.AX4562.01/10/2012.30/11/2012..11289.60
>
> 12345.AX4653.02/10/2012.30/11/2012..45678.45
>
> 12345.AX4653.02/11/2012.31/12/2012..11235.78
>
> 12346.AX8657.04/10/2012.30/11/2012...4567.60
>
> 12346.AX7658.07/10/2012.30/11/2012...3456.45
>
> 12346.AX9248.08/11/2012.31/12/2012...2589.78
>
> 12347.AX4258.06/10/2012.30/11/2012.111269.60
>
> 12347.AX4796.12/10/2012.30/11/2012..33789.45
>
> 12347.AX6987.10/11/2012.31/12/2012560.78
> ...and so on 
>
>
>
> I wish to send a reminder / dunning letters by e mail as follows
> ==
>
>
> === start of 1st reminder email to fancy...@hotmail.com 
> ==
>
> To
> M/s Fancy Paint Shop =>
> PO Box 322   =>
> Madras   =>  all above from the master !
>
> Date : 19 Dec 2012 (basically run date) 
>
> Dear Sir, Madam
>
> You account is overdue by Rs. 56,968.05. Please effect payment immediately 
> to avoid delays in supply. A list of invoices due on your account is given 
> below
>
> Customer 
> #Invoice#...InvoiceDate.DueDateAmount_Due(Rs)
>
> 12345.AX4562.01/10/2012.30/11/2012..11289.60
>
> 12345.AX4653.02/10/2012.30/11/2012..45678.45
>
> Should you need anything more please contact Subu at ..@yahoo.com or 
> at +98354xyzab for further information
>
> Thanking you
> Yours Sincerely
>
> Subu
> === end of 1st dunning email ===
>
> As you would have noticed the next reminder / dunning letter would be of 
> the same format but different in the due amount and list of invoices 
>
>
>
> = Start of 2nd reminder / dunning email to 
> bright...@gmail.com===
>
>
> To
> M/s Bright Colours   =>
> PO Box 123   =>
> Cochin   =>  all above from the master !
>
> Date : 19 Dec 2012 (basically run date) 
>
> Dear Sir, Madam
>
> You account is overdue by Rs. 8024.05. Please effect payment immediately 
> to avoid delays in supply. A list of invoices due on your account is given 
> below
>
> Customer 
> #Invoice#...InvoiceDate.DueDateAmount_Due(Rs)
>
> 12346..

$$Excel-Macros$$ splitting the column

[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 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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.




query.xls
Description: MS-Excel spreadsheet

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

[NOORAIN ANSARI]

Dear Rajesh,

see attachment, Hope it will help to you.

On Thu, Dec 27, 2012 at 4:40 PM, Rajesh Agarwal  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*
> *9811063001*
>
> --
> 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, 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.




query(Rajesh).xls
Description: MS-Excel spreadsheet

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

[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 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 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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

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

[Prince]

Hi Rajesh,

Please see another way of doing the Same: 

=MID(A2,1,FIND("*",SUBSTITUTE(A2," ","*",1),1)) in Cell B2
=SUBSTITUTE(A2,B2,"") in Cell C2

On Thursday, December 27, 2012 4:40:50 PM UTC+5:30, rajeyssh 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*
> *9811063001*
>  

-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

$$Excel-Macros$$ Hi

[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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

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

[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 
To: excel-macros@googlegroups.com 
Sent: Thursday, 27 December 2012, 14:49
Subject: $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to 
customers  using VBA
 

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 19, 2012 11:15:21 AM UTC, .. wrote:
Dear List members
>
>
>Request : Mail merge and E mail using VBA or other tools 
>== == =
>   * I have to send reminder / dunning letters to my customers. 
>
>   * Unfortunately the faxing option from the company is very time 
> consuming (print, sort, fax, wait for dial tones...failure etc etc) and it 
> takes a long time. 
>
>   * Also there isn't a corporate e mail reminder solution in sight. 
>
>   * To avoid delays and very heavy workload, I plan to e mail the 
> reminder / dunning letters. I have to take this personally 
>
>   * I think this should be possible to partially automate this task using 
> XL (data) and combining that with word or VBA and send mail thru MS outlook. 
>
>   * I suspect some one may have tried this before 
>
>   * I seek your help for innovative solutions...either VBA or any other 
> innovative solution as well . 
>
>   * All input data would be available as XL files. Samples shown below 
> and XL files also added to this mail 
>
>   * If this has not been tried earlier or if this is too cumbersome, 
> please drop this, ...my advance apologies .
>
>   * Any pointers to other websites are also gratefully acknowledged 
>
>
>
>
>
>THANKS in advance !!!
>
>
>Subu
>
>
>
>
>My customer master looks like this  [xl file enclosed]
>== ==
>Customer#Customer_ Name...Address 
>..E_mail...
>
>
>12345The fancy paint shopPO Box 322,Madras...fancy_ 
>pa...@hotmail.com
>12346Bright Colours.PO Box 
>123,CochinBright_ col...@gmail.com
>12347Best Decor Bangalore..PO Box 456,BangaloreBest_ 
>d...@bestbangl.co.in
>and ...so on .
>
>
>
>
>
>
>My list of overdue invoices looks like this [xl file enclosed] 
>== =
>Customer #Invoice#... InvoiceDate.DueDate... 
>.Amount_Due(Rs)
>12345.AX4562.. ...01/10/2012.30/11/ 2012..11289.60
>12345.AX4653.. ...02/10/2012.30/11/ 2012..45678.45
>12345.AX4653.. ...02/11/2012.31/12/ 2012..11235.78
>12346.AX8657.. ...04/10/2012.30/11/ 2012...4567.60
>12346.AX7658.. ...07/10/2012.30/11/ 2012...3456.45
>12346.AX9248.. ...08/11/2012.31/12/ 2012...2589.78
>12347.AX4258.. ...06/10/2012.30/11/ 2012.111269.60
>12347.AX4796.. ...12/10/2012.30/11/ 2012..33789.45
>12347.AX6987.. ...10/11/2012.31/12/ 2012560.78
>...and so on 
>
>
>
>
>
>
>I wish to send a reminder / dunning letters by e mail as follows
>== == ==
>
>
>
>
>=== start of 1st reminder email to fancy...@hotmail.com ==
>
>
>To                            
>M/s Fancy Paint Shop             =>
>PO Box 322                       =>
>Madras                           =>  all above from the master !
>
>
>Date : 19 Dec 2012 (basically run date) 
>
>
>Dear Sir, Madam
>
>
>You account is overdue by Rs. 56,968.05. Please effect payment immediately to 
>avoid delays in supply. A list of invoices due on your account is given below
>
>
>Customer #Invoice#... InvoiceDate.DueDate... 
>.Amount_Due(Rs)
>12345.AX4562.. ...01/10/2012.30/11/ 2012..11289.60
>12345.AX4653.. ...02/10/2012.30/11/ 2012..45678.45
>
>
>Should you need anything more please contact Subu at ..@yahoo.com or at 
>+98354xyzab for further information
>
>
>Thanking you
>Yours Sincerely
>
>
>Subu
>=== end of 1st dunning email ===
>
>
>As you would have noticed the next reminder / dunning letter would be of the 
>same format but different in the due amount and list of invoices 
>
>
>
>
>
>
>= Start of 2nd reminder / dunning email to bright...@gmail.com ===
>
>
>
>
>To                        

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

[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 the customer faces a discrepancy it takes 
again a lot of time for him to respond via another postal mail  so I am 
forced to use fax or e mail for instant reminders; I explained the problem with 
fax earlier, so the only option left is e mail 

I think others have understood this correctly. Yes I am requesting a way to e 
mail these letters 

I shall answer your other suggestion to change the VBA in the next mail 

 
--


Regards
Subu


mail_to_s...@yahoo.com



 From: bpascal123 
To: excel-macros@googlegroups.com 
Sent: Wednesday, 26 December 2012, 23:38
Subject: $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to 
customers  using VBA
 


Hi,

Happy new year and all... About your query it seems you have 2 queries, one 
related to mail merge (paper) and one to email. I have been working on these 
for my own needs, with more or less access to the content...

For mail merge using email, it seems there are many resources available online 
to automate emails from Excel to Outlook with customs email addresses, subject, 
body and so on

For mail merge using paper (for faxing or post mailing), most available infos 
is about Word and its mail merge tool. For that, at this time, I have just 
managed to make the data "fit" the mail merge tools, like

Customer# Customer_name invoiceNum_1 invoiceDate_1 invoiceDueDate_1 
InvoiceDueAmt_1 invoiceNum_2 invoiceDate_2 invoiceDueDate_2 InvoiceDueAmt_2 … 
invoiceItem_8 address email Total Dues 
12345 The fancy paint shop AX4562 2012-01-10 30/11/2012 11289.6 AX4653 
2012-02-10 30/11/2012 45678.45     PO Box 322,Madras fancy_pa...@hotmail.com 
68203.83 


For one customer, using Word Mail Merge, the data for one customer must be like 
above... Your data is also a bit difficult to deal with, to implement it there 
might be changes in the account info sheet as invoice AX4653 comes with 
multiple invoice date, due date and amount due. Maybe it's a typo because for 
one invoice, there should only be be one invoice date... unless you have 
specific requirements...

Once your data is laid like that you can start the mail merge from Word. The 
header fields as shown above should help Word match its mail merge fields as 
there may be some confusion using an incremental number invoiceNum_1, 
invoiceDate_2... in relation to the column position of each field...

My issue using mail merge comes when invoice information are displayed in a 
table or in a tabular way following your letter layout. There Word mail merge 
decides of the number of rows in the table from the customer that has the 
maximum number of due invoices. Everyone else will have a table size of this 
customer. I'm not an expert of Mail Merge but maybe there is an option 
somewhere that makes Word adjusts the number of rows in the mail merge tool 
accordingly to the number of real invoices for one customer, in your data, it 
seem there is the same number of invoice for each customer ... if one day a 
customer has ten invoices, there will be 10 rows on every table... At this 
stage, I have deleted manually all empty rows while checking every letters... 
If the number of letters is significative, this might be difficult...

Is anyone aware of something to do to "fix" this? I would think of a macro that 
would loop through every table and delete empty rows once the mail merge is 
complete. Else, coding with vba the Word mail merge instead of doing it 
manually from the tool bar might allow more flexibility... Can someone advise?

Using Word mail merge is the fastest possible option. Else copy paste tables 
from Excel would require a significative amount of time and cpu activity. But 
it's then easy to copy only the needed number of rows. One last thing is that 
tables are of Excel range objects... instead of html or xml (loss of word 
document style). Excel range object in Word also make files heavier.

If you could follow me until here, I can help you to the point where I am 
now... presenting the data for Word mail merge tool.

Using emails, things are a little different since most actions can be automated 
from within Excel to Outlook or most email clients. For this, I'm also facing 
an issue... is it possible to code an email html table from Excel using vba 
rather than pasting an Excel object range? I spent some time looking for 
anything related to this on web sites without any success. It seems this is 
possible doing so from Excel to Word as there is a specific table object/method 
available from referencing Word object collections in Excel. Is there anything 
similar with email, Outlook?

Thanks
Pascal
-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discu

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

[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 Outlook 11 Object Library from Tools - 
Reference within VBA

Microsoft Outlook 11 Object Library is what I can see I do NOT see Outlook 9 
object library on my machine 


This is what I have done http://bit.ly/V83tIm
Screen shot file name Screenshot - 12_27_2012 , 11_35_33 PM.png enclosed 

When I try your  piece of code, after the above setting, I get this error 
http://bit.ly/UoOKL8
Screen shot file name Screenshot - 12_28_2012 , 12_00_08 AM.png enclosed 


The same errors appear even IF I do NOT add reference (or remove the reference) 
to MS Outlook 11 object library in VBA Editor -> tools -> References 

Thanks in advance for your help 

--


Regards
Subu


mail_to_s...@yahoo.com



 From: bpascal123 
To: excel-macros@googlegroups.com 
Cc: "aks.sharm...@gmail.com" ; Subu S 
 
Sent: Wednesday, 26 December 2012, 23:56
Subject: Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to 
customers using VBA
 

change 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

-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post 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

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.


<>

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

[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 final 
answers for all the sets of data all the time.
 
I'm thinking I need to do some event tracking on the calc sheet - tracking 
when the values in the final calculation cells change - but I only know how 
to track cells changes which are data, not cells which are formula.
 
 

-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

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

[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 
man delivers mails, left a notification about a letter to pick-up at his 
local post office). Following usual rules, until he picks-up, the recipient 
is not aware of the originator or where the mail is from. So even if a 
letter takes longer, in the end you have a solid proof the person you have 
sent the letter to has gotten it..

On Thursday, December 27, 2012 7:57:35 PM UTC, .. wrote:
>
> 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 the customer faces a discrepancy it 
> takes again a lot of time for him to respond via another postal mail 
>  so I am forced to use fax or e mail for instant reminders; I 
> explained the problem with fax earlier, so the only option left is e mail 
>
> I think others have understood this correctly. Yes I am requesting a way 
> to e mail these letters 
>
> I shall answer your other suggestion to change the VBA in the next mail 
>
>  
> --
>
> Regards
> Subu
>
>
> mail_t...@yahoo.com 
>   --
> *From:* bpascal123 >
> *To:* excel-...@googlegroups.com  
> *Sent:* Wednesday, 26 December 2012, 23:38
> *Subject:* $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to 
> customers using VBA
>  
>
> Hi,
>
> Happy new year and all... About your query it seems you have 2 queries, 
> one related to mail merge (paper) and one to email. I have been working on 
> these for my own needs, with more or less access to the content...
>
> For mail merge using email, it seems there are many resources available 
> online to automate emails from Excel to Outlook with customs email 
> addresses, subject, body and so on
>
> For mail merge using paper (for faxing or post mailing), most available 
> infos is about Word and its mail merge tool. For that, at this time, I have 
> just managed to make the data "fit" the mail merge tools, like
>
> *Customer#*
> *Customer_name*
> *invoiceNum_1*
> *invoiceDate_1*
> *invoiceDueDate_1*
> *InvoiceDueAmt_1*
> *invoiceNum_2*
> *invoiceDate_2*
> *invoiceDueDate_2*
> *InvoiceDueAmt_2*
> *…*
> *invoiceItem_8*
> *address*
> *email*
> *Total Dues*
> 12345
> The fancy paint shop
> AX4562
> 2012-01-10
> 30/11/2012
> 11289.6
> AX4653
> 2012-02-10
> 30/11/2012
> 45678.45
>  
>  
> PO Box 322,Madras
> fancy...@hotmail.com 
> 68203.83
>
>
> For one customer, using Word Mail Merge, the data for one customer must be 
> like above... Your data is also a bit difficult to deal with, to implement 
> it there might be changes in the account info sheet as invoice AX4653 comes 
> with multiple invoice date, due date and amount due. Maybe it's a typo 
> because for one invoice, there should only be be one invoice date... unless 
> you have specific requirements...
>
> Once your data is laid like that you can start the mail merge from Word. 
> The header fields as shown above should help Word match its mail merge 
> fields as there may be some confusion using an incremental number 
> invoiceNum_1, invoiceDate_2... in relation to the column position of each 
> field...
>
> My issue using mail merge comes when invoice information are displayed in 
> a table or in a tabular way following your letter layout. There Word mail 
> merge decides of the number of rows in the table from the customer that has 
> the maximum number of due invoices. Everyone else will have a table size of 
> this customer. I'm not an expert of Mail Merge but maybe there is an option 
> somewhere that makes Word adjusts the number of rows in the mail merge tool 
> accordingly to the number of real invoices for one customer, in your data, 
> it seem there is the same number of invoice for each customer ... if one 
> day a customer has ten invoices, there will be 10 rows on every table... At 
> this stage, I have deleted manually all empty rows while checking every 
> letters... If the number of letters is significative, this might be 
> difficult...
>
> Is anyone aware of something to do to "fix" this? I would think of a macro 
> that would loop through every table and delete empty rows once the mail 
> merge is complete. Else, coding with vba the Word mail merge instead of 
> doing it manually from the tool bar might allow ...
> Show 
> original
>

-- 
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 He

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

[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 Object

Set olApp = CreateObject("Outlook.Application")

MsgBox olApp.Name

End Sub

from this code and see what the sub returns. It should return something.

About adding manually the library, called early binding, I meant Microsoft 
Outlook 11 Object Library
I have just copied paste from an older internet site.

Using either method, I'm not then sure if your error is related to the 
outlook object variable declared in excel. I'm not fully aware of outlook 
objects. To me it seems the line with Outlook.Folder should be changed to 
something else.

Maybe this should help (again i'm not a professional of outlook objects)

Dim olFolder As Outlook.MAPIFolder
Set olFolder = olNamespace.GetDefaultFolder(olFolderInbox) 

HTH
Pascal

On Thursday, December 27, 2012 8:09:42 PM UTC, .. wrote:

>
> 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 Outlook 11 Object Library from 
> Tools - Reference within VBA
> Microsoft Outlook 11 Object Library is what I can see I do NOT see Outlook 
> 9 object library on my machine 
>
> This is what I have done http://bit.ly/V83tIm
> Screen shot file name Screenshot - 12_27_2012 , 11_35_33 PM.png enclosed 
>
> When I try your  piece of code, after the above setting, I get this error 
> http://bit.ly/UoOKL8
> Screen shot file name Screenshot - 12_28_2012 , 12_00_08 AM.png enclosed 
>
> The same errors appear even IF I do NOT add reference (or remove the 
> reference) to MS Outlook 11 object library in VBA Editor -> tools -> 
> References 
>
> Thanks in advance for your help 
>
> --
>
> Regards
> Subu
>
>
> mail_t...@yahoo.com 
>   --
> *From:* bpascal123 >
> *To:* excel-...@googlegroups.com  
> *Cc:* "aks.sh...@gmail.com " >; 
> Subu S > 
> *Sent:* Wednesday, 26 December 2012, 23:56
> *Subject:* Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to 
> customers using VBA
>  
> change 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
> -- 
> 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, 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post 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.
>  
>  
>
>
>  

-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

Re: $$Excel-Macros$$ Hi

[NOORAIN ANSARI]

Dear Rajat,

You have been added successfully in excel-macros group,
Please check and confirm.



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

On Thu, Dec 27, 2012 at 9:57 PM, rajat arora
wrote:

> rajat198...@yahoo.com
>




-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

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

[mail_to_subu]

GentlemenI really appreciate both of you trying to help 
meLet me wait for Anoop's reply 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 
mailRegardsSubu

-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

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

[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 wrote:

> Hi Hilary / Prince Sir,
> In the excel sheet, if you see in sheet2, then NH No, Name of the
> section...and Car tye.  In car type i have :-
>   Car/Jeep/Van Single Entry  Car/Jeep/Van Multiple Entry  Car/Jeep/Van Reusage
> of Multiple Entry   Car/Jeep/Van Reusages of Monthly Passes   Car/Jeep/Van
> Exempt
> ..
> Again we have for LCV, TRUCK/BUS, HCM/EME, .so on
> Same like above for LCV, Truck/Bus.
>
> Now , i want all the column wise into row wise to make easier for pivot
> table. like in the sheet1. please refer sheet 1.
> i have done for -Manor- Dahisar. by copy and paste.
>
>i am not aware of that how to do. Ok any way if i am unable to
> explain you all then very frankly tell you all expert that i want the
> counts of vehicle wise by year or month. i have attached the file and i
> want pivot table like sheet provided. but it is very difficult for me to to
> do by one by one.
>
> Thanks for the revert.
>
>
> Thanks & Regards,
> Koneng
>
>
>
>
>
>
>
> On Thu, Dec 27, 2012 at 1:18 PM, Bhaity Koneng wrote:
>
>> Hi experts,
>>
>>it is my first post and here i have attached a excel which i am
>> doing manaully copy and past. and it took me time of 6 hours. i have
>> another 100 to do , i have cmpleted just only 3 and it took me 6 hours. i
>> dont know how to complete that, if i do manually it will take 4-5 months to
>> complete that.
>> Any advice or suggestions how to do this a bit quicker than me.
>>
>> Thank you Gurus and please advice me some more tips to learn and have
>> ideas in excel.
>>
>>
>> Regards,
>> Koneng
>>
>> --
>> 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, 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

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

[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 receive while this person is away.This 
e-mail is confidential and, if you are not the intended recipient, please 
return it to us and do not retain or disclose it. We filter and monitor e-mails 
in order to protect our system and the integrity, confidentiality and 
availability of e-mails. We cannot guarantee that e-mails are risk free and are 
not responsible for any related damage or unauthorised alteration of e-mails by 
third parties after sending. 

For more information on Standard Life group, visit our website  
http://www.standardlife.com/ 

Standard Life plc (SC286832), Standard Life Assurance Limited* (SC286833) and 
Standard Life Employee Services Limited (SC271355) are all registered in 
Scotland at Standard Life House, 30 Lothian Road, Edinburgh EH1 2DH. 
*Authorised and regulated by the Financial Services Authority. 0131 225 2552. 
Calls may be recorded/monitored. Standard Life group includes Standard Life plc 
and its subsidiaries.  

-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

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

[mail_to_subu]

Dear pascal My rule : ===1. bad / 
terrible customer -> proof ... Signature ... Etc2. Most normal 
customers and even late payers but honest payers  : email. Fast gets the job 
done without fussAlso please note that e commerce legislation is 
improving by the day and all the green ( don't print ) thinking is moving 
heavily in this direction of e mail statements and reminders Check 
with your company lawyers on agreements with customers on how to bind them to 
accept e statement and e reminders You will be amazed at the new 
thinking Even banks have implemented this 
!!!RegardsSubu 


-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

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

[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, Bhaity Koneng 
> 
> > wrote:
>
>> Hi Hilary / Prince Sir,
>> In the excel sheet, if you see in sheet2, then NH No, Name of the 
>> section...and Car tye.  In car type i have :-
>>   Car/Jeep/Van Single Entry  Car/Jeep/Van Multiple Entry  Car/Jeep/Van 
>> Reusage 
>> of Multiple Entry   Car/Jeep/Van Reusages of Monthly Passes   
>> Car/Jeep/Van Exempt 
>> ..
>> Again we have for LCV, TRUCK/BUS, HCM/EME, .so on
>> Same like above for LCV, Truck/Bus.
>>  
>> Now , i want all the column wise into row wise to make easier for pivot 
>> table. like in the sheet1. please refer sheet 1. 
>> i have done for -Manor- Dahisar. by copy and paste.
>>  
>>i am not aware of that how to do. Ok any way if i am unable to 
>> explain you all then very frankly tell you all expert that i want the 
>> counts of vehicle wise by year or month. i have attached the file and i 
>> want pivot table like sheet provided. but it is very difficult for me to to 
>> do by one by one.
>>  
>> Thanks for the revert.
>>  
>>  
>> Thanks & Regards,
>> Koneng
>>  
>>  
>>  
>>  
>>
>>
>>
>> On Thu, Dec 27, 2012 at 1:18 PM, Bhaity Koneng 
>> 
>> > wrote:
>>
>>> Hi experts,
>>>  
>>>it is my first post and here i have attached a excel which i am 
>>> doing manaully copy and past. and it took me time of 6 hours. i have 
>>> another 100 to do , i have cmpleted just only 3 and it took me 6 hours. i 
>>> dont know how to complete that, if i do manually it will take 4-5 months to 
>>> complete that. 
>>> Any advice or suggestions how to do this a bit quicker than me.
>>>  
>>> Thank you Gurus and please advice me some more tips to learn and have 
>>> ideas in excel. 
>>>  
>>>  
>>> Regards,
>>> Koneng
>>>
>>> -- 
>>> 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, 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>  
>>> NOTE : Don't ever post 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.
>>>  
>>>  
>>>
>>
>>
>

-- 
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, 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.

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

[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,  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 end result is something that will help me and
> also help many others trying to send automated / format letters over e mail
>
>
> Regards
>
>
> Subu
>
>
>
>
>  --
> * From: * bpascal123 ;
> * To: * ;
> * Cc: * aks.sharm...@gmail.com ;
> bpascal...@gmail.com ; Subu S <
> mail_to_s...@yahoo.com>;
> * Subject: * Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email
> to customers using VBA
> * Sent: * Fri, Dec 28, 2012 1:30:00 AM
>
>   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 Object
>
> Set olApp = CreateObject("Outlook.Application")
>
> MsgBox olApp.Name
>
> End Sub
>
> from this code and see what the sub returns. It should return something.
>
> About adding manually the library, called early binding, I meant Microsoft
> Outlook 11 Object Library
> I have just copied paste from an older internet site.
>
> Using either method, I'm not then sure if your error is related to the
> outlook object variable declared in excel. I'm not fully aware of outlook
> objects. To me it seems the line with Outlook.Folder should be changed to
> something else.
>
> Maybe this should help (again i'm not a professional of outlook objects)
>
> Dim olFolder As Outlook.MAPIFolder
> Set olFolder = olNamespace.GetDefaultFolder(olFolderInbox)
>
> HTH
> Pascal
>
> On Thursday, December 27, 2012 8:09:42 PM UTC, .. wrote:
>
>>
>> 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 Outlook 11 Object Library from
>> Tools - Reference within VBA
>> Microsoft Outlook 11 Object Library is what I can see I do NOT see
>> Outlook 9 object library on my machine
>>
>> This is what I have done http://bit.ly/V83tIm
>> Screen shot file name Screenshot - 12_27_2012 , 11_35_33 PM.png enclosed
>>
>> When I try your  piece of code, after the above setting, I get this error
>> http://bit.ly/UoOKL8
>> Screen shot file name Screenshot - 12_28_2012 , 12_00_08 AM.png enclosed
>>
>> The same errors appear even IF I do NOT add reference (or remove the
>> reference) to MS Outlook 11 object library in VBA Editor -> tools ->
>> References
>>
>> Thanks in advance for your help
>>
>> --
>>
>> Regards
>> Subu
>>
>>
>> mail_t...@yahoo.com
>>   --
>> *From:* bpascal123 
>> *To:* excel-...@googlegroups.com
>> *Cc:* "aks.sh...@gmail.com" ; Subu S <
>> mail_t...@yahoo.com>
>> *Sent:* Wednesday, 26 December 2012, 23:56
>> *Subject:* Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email
>> to customers using VBA
>>
>> change 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
>> --
>> 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, 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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
>> .
>>
>>
>>
>>
>>   --
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not b