$$Excel-Macros$$ Help on Outlook Vba - Auto reply with name and greetings
Hi Experts, I found the below Vba Code for Inserting name in reply or inserting greeting in reply automatically. Sub InsertNameInReply() Dim Msg As Outlook.MailItem Dim MsgReply AsOutlook.MailItem Dim strGreetName As String Dim lGreetType As Long ' set reference to open/selected mail item On Error Resume Next Select CaseTypeName(Application.ActiveWindow) Case Explorer Set Msg = ActiveExplorer.Selection.item(1) Case Inspector Set Msg = ActiveInspector.CurrentItem Case Else End Select On Error Goto 0 If Msg Is Nothing Then Goto ExitProc ' figure out greeting line On Error Resume Next lGreetType = InputBox(How to greet: vbCr vbCr Type '1' for name, '2' for time of day) On Error Goto 0 If lGreetType = False Then Goto ExitProc If lGreetType = 1 Then strGreetName = Left$(Msg.SenderName, InStr(1, Msg.SenderName, ) - 1) ElseIf lGreetType = 2 Then Select CaseTime Case Is 0.5 strGreetName = Good morning Case 0.5 To 0.75 strGreetName = Good afternoon Case Else strGreetName = Good evening End Select Else ' something else entered?? Goto ExitProc End If Set MsgReply = Msg.Reply WithMsgReply .Subject = RE: Msg.Subject .HTMLBody = span style=font-family : verdana;font-size : 10ptpHello strGreetName ,/p/span .HTMLBody .Display End With ExitProc: Set Msg = Nothing Set MsgReply = Nothing End Sub But actually I am looking for insertion of both ie Name as well as greetings automatically. Please help on it. Regards, Kaushik Savla -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs
I think Mr Aysush should ban him for this violation!! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: garwads...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 1 Dec 2011 16:51:50 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs Be surya in sky ,and don't come here to shine with cheap stuff around. Respect the motive of this forum and I hope Ayush doesn't vanish u with this cheap act, be careful !!! Cheers Rahul. Sent from BlackBerry® on Airtel -Original Message- From: Ashish Pradhan ashlyprad...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 01 Dec 2011 22:16:42 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs Excel Forums now-a-days being used for marketing activities Ashish On 01/12/2011 20:39, Mr Excellent wrote: Hi, Join the Fashion Group and get 1000rs on intial enrollment and get waived off in the initial transaction Fashion Group : A Place with more discounts and less money incurred...join in and believe it Believe it with below link : http://www.fashionandyou.com/fashionandyou-client-http-shop/shop Thanks Surya -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday
Hi Sam Thanks for the update now my problem has resloved as i have checked with the IT people they provide me the solution now i m able to send mails On Sun, Dec 4, 2011 at 5:44 PM, Sam Mathai Chacko samde...@gmail.comwrote: IT administrators mostly disable this option in the office environment to ensure that no unwanted risk lies open by taking off outlook security. If you are not able to change the option, then I am afraid I do not have a solution. Maybe someone from the forum can share some advice? Regards Sam Mathai Chacko On Sun, Dec 4, 2011 at 12:59 PM, maulik desai mauliksde...@gmail.comwrote: Thanks sam, I just want to ask u that i have try the option at my house but i can not able to change the option in my office pc so is there any other option or any macro code for outlook which can solve my problem sorry for late reply. On Tue, Nov 29, 2011 at 7:22 PM, Sam Mathai Chacko samde...@gmail.comwrote: Go to ToolsMacroSecurityProgrammatic AccessNever Warn Sam On Tue, Nov 29, 2011 at 8:28 AM, maulik desai mauliksde...@gmail.comwrote: Thanks you so much deepak for your great support lastly i just want to ask you 1 thing that when ever i clicked on Macro for mail send microsoft gives me pop up for stating that whould you like to send this mail (with allow or dinied option ) so every time i have to click allow buttion is there any why to remove this pop uo windlow rest everytrhing working fine pls revert with solution thanks once again.. On Wed, Nov 23, 2011 at 10:14 AM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Attached is the updated file, now you won't need to prepare a separate table to get channel wise unique email id's... On Mon, Nov 21, 2011 at 10:09 PM, maulik desai mauliksde...@gmail.com wrote: Thanks Deepak, Actually those id;'s i cant disclose it but yes Email ids are not common it is also not based on channel name.its is based on location wise its always get change so i suggest you to kindly add the new column after G or After M Actaully My Database is from A to G if u add the new col then From A To H , actually there is no summry sheet (From K to M ,if u want u can remove the column L(person name ) from summary sheet can add in main database after col F so while macro prepares summry sheet it will be easy for me to get data) i have just shown to u for ref actaully i want it like once i update the database in column A to H , Macro can create the summry sheet based on unique list then send the mail to mail ids (from To in CC fields) Thanks On Mon, Nov 21, 2011 at 10:56 AM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Sure Maulik... I just want to know those email ids (which you want to add in CC BCC) are common or they'll be changed with every channel name...?? Regards Deepak On Sun, Nov 20, 2011 at 2:43 PM, maulik desai mauliksde...@gmail.com wrote: Thanks you so much deepak for your effort sorry for late reply becasue i can not able to use Gmail from my office pc i check your file it is working very well just one thing i want to ask u that i want to add some email id on CC BCC can u please help in this that how can i do that. while data pasted to mail body , bottom line of table is not reflected . Request you to please look in small chnages revert Thnaks in Advance.. On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Here it is I developed this code on 2007 platform..I hope it'll work in 2003 as well... Sorry.. I couldn't attached the excel file with my previous post because I's in office at that time can't access to gmail over there... Regards Deepak On Tue, Nov 15, 2011 at 11:32 PM, maulik desai mauliksde...@gmail.com wrote: Hi deepu, Thanks you so much for your reply I have tried to paste the code in module but it not work properly request you to kindly provide me the excel sheet with your macro code but before you send me the file required small changes do not use K M column for Chennel name email address that is given just for information my actual database is from A to G request you to kindly change the macro code accordingly send it back for the other checks also if you want u can create the summary sheet with the help of macro paste it on sheet 2 also for name u can use Column H for the proper output.1 more thing i want to tell you that a have to send mail with our official signature so if u can apply macro logic for the same also it would be very great ful to u. Request you to kindly make the changes resend it for the final check Thanks in Advance thanks for your time support. On Mon, Nov 14, 2011 at 4:10 PM, deepu deepaktheind...@gmail.com wrote: Hi Maulik, Below is the code that you're looking for... Insert a module in your workbook and paste the following code and run it...
Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....
hi den thanks for the reply i am working for international firm as sr. Mis executive and this is for 1 of my monthly report prepration part i am from mumbai and we have every week new joinees coming to company and according to that we have to create diff batch codes bases on location,process,subprocess and batch code below is the same exp for ur ref which is updated in a column On 12/4/11, dguillett1 dguille...@gmail.com wrote: 1. You give NO examplePerhaps a list and then “for each item in range(“a2:a11”) 2. Adaptable to a worksheet_change event 3. Can be done Who are you_,Where are you___Who do you work forWhat is this for??_ Don Guillett SalesAid Software dguille...@gmail.com From: maulik desai Sent: Sunday, December 04, 2011 1:41 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Thanks don very sorry for late reply i was not in town for a week I just want to some changes from you I have added the macro lines as requested by you (PFA file)kindly check the same modify according to requirement (also mention some comments in macro code kindly check also) 3 changes i want from you that 1.batch code is not based on Batch 1 batch 2 on as i mentioned in my previous mail it could be any thing so kindly make the changes in bach code area 2.In my old file i have used worksheet change event as once i run the code after that i have make many changes as per the requirement that is not for all batches so it is very diff to always run the complete macro for small small changes that is why i have apply worksheet event so when ever i change the data for some batch i used to press F2 in that batch code details gets changed so that thing is very imp for this report 3.as every month i have to apply macro for more then 550 unique batches its take 15 to 20 mins to update so i want the process bar which can show me the status like in % or how many columns are remaining. Hope i understood u properly Thanks in advance sorry once again for late replyawaiting for your reply with updated code.. On Mon, Nov 21, 2011 at 10:41 PM, dguillett1 dguille...@gmail.com wrote: Always best to use the actual file. Don Guillett SalesAid Software dguille...@gmail.com From: maulik desai Sent: Monday, November 21, 2011 10:52 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Don, Thanks you so much for your response but i just want to tell that actual batch code are not in series like batch 1, batch 2 etc it is based on process sub process name also based on location then No so i can say there is no fixed format for the batch code also give me 1 days time i will update the remaining code send u batch mean while your can change the code becasue currenly it is based on batch 1 batch 2 as u mentioned also can i get the progress bar for the same . I must say it is very efficient code thanks for that for now it took 1 or 2 sec to update i hope in real file it will help me also Thanks On Sun, Nov 20, 2011 at 11:17 PM, dguillett1 dguille...@gmail.com wrote: I have gone thru and re-written your code to be more efficient. I see no real need to do with a worksheet change event as it will be fast even with 750 rows. It starts with a clean sheet beginning at row 7 assuming your Batch’s are actually named Batch 1, batch 2, etc. Click to see!! Don Guillett SalesAid Software dguille...@gmail.com From: maulik desai Sent: Sunday, November 20, 2011 3:21 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Don, Thanks for your reply i am so sorry for late reply acctually i can not able to use gmail from my office pc here i am attaching the Format of my file as requested, kindly check the macro code i want to requce the code size normally it takes 20 to 30 mins currently it has just a dummy data so it will give faster result but acctually on Batch sheet it contains more then 750 rows on a monthly basis Request you to kindly do the needful thanks in advance. On Mon, Nov 14, 2011 at 6:47 PM, dguillett1 dguille...@gmail.com wrote: Attach your file with a reply to this msg. Don Guillett SalesAid Software dguille...@gmail.com From: maulik desai Sent: Sunday, November 13, 2011 10:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Team, I having 1 excel sheet in that i have apply below Sumproduct macro code 72 times to get output on my database (This code is provided by Daniel of this group ) my But my problem is it take about 20 to
Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....
Thakns All but i want this progress bar with my exsiting macro code not in seprate code as far i understood for progress bar u have to do loop code but i dont understand how to apply processbar code in my exsisting Sumproduct macro code kindly provide your help provide me the solution Thanks On Wed, Dec 7, 2011 at 7:26 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: chk attachment On Tue, Dec 6, 2011 at 12:51 PM, maulik desai mauliksde...@gmail.comwrote: hi don, thanks for the reply i am working for international firm as sr. Mis executive and this is for 1 of my monthly report prepration part i am from mumbai and we have every week new joinees coming to company and according to that we have to create diff batch codes bases on location,process,subprocess and batch code below is the same exp for ur ref which is updated in a column batch code updated as chsdc 21 chbserrca 12 ch-slh-batch 20 ch-acd-batch 3 gn/avf/dc doc/22 ok/eb sales/batch 32 gn/nahd nh/batch 12_11 cwcdrlcc 1 tb/co/batch 163 bc/mnb/batch 3 vf/ert/eb/batch ss 5 above mentioned batch codes are just part of total batches so aa i told u befor there is no fixed style of batch code so request u to kindly apply code with free text logic like if from a7 if anything is entered it should give the output and same logic implimented in original file hope i have understood u properly... Request u to kindly make the necessury changes and resend the updated file thanks in advance On 12/4/11, dguillett1 dguille...@gmail.com wrote: 1. You give NO examplePerhaps a list and then “for each item in range(“a2:a11”) 2. Adaptable to a worksheet_change event 3. Can be done Who are you_,Where are you___Who do you work forWhat is this for??_ Don Guillett SalesAid Software dguille...@gmail.com From: maulik desai Sent: Sunday, December 04, 2011 1:41 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Thanks don very sorry for late reply i was not in town for a week I just want to some changes from you I have added the macro lines as requested by you (PFA file)kindly check the same modify according to requirement (also mention some comments in macro code kindly check also) 3 changes i want from you that 1.batch code is not based on Batch 1 batch 2 on as i mentioned in my previous mail it could be any thing so kindly make the changes in bach code area 2.In my old file i have used worksheet change event as once i run the code after that i have make many changes as per the requirement that is not for all batches so it is very diff to always run the complete macro for small small changes that is why i have apply worksheet event so when ever i change the data for some batch i used to press F2 in that batch code details gets changed so that thing is very imp for this report 3.as every month i have to apply macro for more then 550 unique batches its take 15 to 20 mins to update so i want the process bar which can show me the status like in % or how many columns are remaining. Hope i understood u properly Thanks in advance sorry once again for late replyawaiting for your reply with updated code.. On Mon, Nov 21, 2011 at 10:41 PM, dguillett1 dguille...@gmail.com wrote: Always best to use the actual file. Don Guillett SalesAid Software dguille...@gmail.com From: maulik desai Sent: Monday, November 21, 2011 10:52 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Don, Thanks you so much for your response but i just want to tell that actual batch code are not in series like batch 1, batch 2 etc it is based on process sub process name also based on location then No so i can say there is no fixed format for the batch code also give me 1 days time i will update the remaining code send u batch mean while your can change the code becasue currenly it is based on batch 1 batch 2 as u mentioned also can i get the progress bar for the same . I must say it is very efficient code thanks for that for now it took 1 or 2 sec to update i hope in real file it will help me also Thanks On Sun, Nov 20, 2011 at 11:17 PM, dguillett1 dguille...@gmail.com wrote: I have gone thru and re-written your code to be more efficient. I see no real need to do with a worksheet change event as it will be fast even with 750 rows. It starts with a clean sheet beginning at row 7 assuming your Batch’s are actually named Batch 1, batch 2, etc. Click to see!! Don Guillett SalesAid Software dguille...@gmail.com From: maulik desai Sent: Sunday, November 20, 2011 3:21 AM To: excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....
Dh Don, awaiting for your reply with final output... Thanks On Sun, Dec 4, 2011 at 7:09 PM, dguillett1 dguille...@gmail.com wrote: 1. You give NO example[image: Sleeping half-moon]Perhaps a list and then “for each item in range(“a2:a11”) 2. Adaptable to a worksheet_change event 3. Can be done Who are you_,Where are you___Who do you work forWhat is this for??_ Don Guillett SalesAid Software dguille...@gmail.com *From:* maulik desai mauliksde...@gmail.com *Sent:* Sunday, December 04, 2011 1:41 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Thanks don very sorry for late reply i was not in town for a week I just want to some changes from you I have added the macro lines as requested by you (PFA file)kindly check the same modify according to requirement (also mention some comments in macro code kindly check also) 3 changes i want from you that 1.batch code is not based on Batch 1 batch 2 on as i mentioned in my previous mail it could be any thing so kindly make the changes in bach code area 2.In my old file i have used worksheet change event as once i run the code after that i have make many changes as per the requirement that is not for all batches so it is very diff to always run the complete macro for small small changes that is why i have apply worksheet event so when ever i change the data for some batch i used to press F2 in that batch code details gets changed so that thing is very imp for this report 3.as every month i have to apply macro for more then 550 unique batches its take 15 to 20 mins to update so i want the process bar which can show me the status like in % or how many columns are remaining. Hope i understood u properly Thanks in advance sorry once again for late replyawaiting for your reply with updated code.. On Mon, Nov 21, 2011 at 10:41 PM, dguillett1 dguille...@gmail.com wrote: Always best to use the actual file. Don Guillett SalesAid Software dguille...@gmail.com *From:* maulik desai mauliksde...@gmail.com *Sent:* Monday, November 21, 2011 10:52 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Don, Thanks you so much for your response but i just want to tell that actual batch code are not in series like batch 1, batch 2 etc it is based on process sub process name also based on location then No so i can say there is no fixed format for the batch code also give me 1 days time i will update the remaining code send u batch mean while your can change the code becasue currenly it is based on batch 1 batch 2 as u mentioned also can i get the progress bar for the same . I must say it is very efficient code thanks for that for now it took 1 or 2 sec to update i hope in real file it will help me also Thanks On Sun, Nov 20, 2011 at 11:17 PM, dguillett1 dguille...@gmail.comwrote: I have gone thru and re-written your code to be more efficient. I see no real need to do with a worksheet change event as it will be fast even with 750 rows. It starts with a clean sheet beginning at row 7 assuming your Batch’s are actually named Batch 1, batch 2, etc. Click to see!! Don Guillett SalesAid Software dguille...@gmail.com *From:* maulik desai mauliksde...@gmail.com *Sent:* Sunday, November 20, 2011 3:21 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Don, Thanks for your reply i am so sorry for late reply acctually i can not able to use gmail from my office pc here i am attaching the Format of my file as requested, kindly check the macro code i want to requce the code size normally it takes 20 to 30 mins currently it has just a dummy data so it will give faster result but acctually on Batch sheet it contains more then 750 rows on a monthly basis Request you to kindly do the needful thanks in advance. On Mon, Nov 14, 2011 at 6:47 PM, dguillett1 dguille...@gmail.comwrote: Attach your file with a reply to this msg. Don Guillett SalesAid Software dguille...@gmail.com *From:* maulik desai mauliksde...@gmail.com *Sent:* Sunday, November 13, 2011 10:31 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Team, I having 1 excel sheet in that i have apply below Sumproduct macro code 72 times to get output on my database (This code is provided by Daniel of this group ) my But my problem is it take about 20 to 30 mins to run the code total 550 row(not fixed) x 72 columns ) what I want that can i get a progress bar which shows me status like 3 outof 72 columns completed or 10%,15% ,30% completed like that also if can help to reduce the code size to work faster Please
Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday
Hi Maulik, Good to know as there is a solution for that problem. Request you please share the same knowledge as I have same issue with me. Thanks, Sent on my BlackBerry® from Vodafone Thanks Regards. Kiran -Original Message- From: maulik desai mauliksde...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 11 Dec 2011 14:31:50 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday Hi Sam Thanks for the update now my problem has resloved as i have checked with the IT people they provide me the solution now i m able to send mails On Sun, Dec 4, 2011 at 5:44 PM, Sam Mathai Chacko samde...@gmail.comwrote: IT administrators mostly disable this option in the office environment to ensure that no unwanted risk lies open by taking off outlook security. If you are not able to change the option, then I am afraid I do not have a solution. Maybe someone from the forum can share some advice? Regards Sam Mathai Chacko On Sun, Dec 4, 2011 at 12:59 PM, maulik desai mauliksde...@gmail.comwrote: Thanks sam, I just want to ask u that i have try the option at my house but i can not able to change the option in my office pc so is there any other option or any macro code for outlook which can solve my problem sorry for late reply. On Tue, Nov 29, 2011 at 7:22 PM, Sam Mathai Chacko samde...@gmail.comwrote: Go to ToolsMacroSecurityProgrammatic AccessNever Warn Sam On Tue, Nov 29, 2011 at 8:28 AM, maulik desai mauliksde...@gmail.comwrote: Thanks you so much deepak for your great support lastly i just want to ask you 1 thing that when ever i clicked on Macro for mail send microsoft gives me pop up for stating that whould you like to send this mail (with allow or dinied option ) so every time i have to click allow buttion is there any why to remove this pop uo windlow rest everytrhing working fine pls revert with solution thanks once again.. On Wed, Nov 23, 2011 at 10:14 AM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Attached is the updated file, now you won't need to prepare a separate table to get channel wise unique email id's... On Mon, Nov 21, 2011 at 10:09 PM, maulik desai mauliksde...@gmail.com wrote: Thanks Deepak, Actually those id;'s i cant disclose it but yes Email ids are not common it is also not based on channel name.its is based on location wise its always get change so i suggest you to kindly add the new column after G or After M Actaully My Database is from A to G if u add the new col then From A To H , actually there is no summry sheet (From K to M ,if u want u can remove the column L(person name ) from summary sheet can add in main database after col F so while macro prepares summry sheet it will be easy for me to get data) i have just shown to u for ref actaully i want it like once i update the database in column A to H , Macro can create the summry sheet based on unique list then send the mail to mail ids (from To in CC fields) Thanks On Mon, Nov 21, 2011 at 10:56 AM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Sure Maulik... I just want to know those email ids (which you want to add in CC BCC) are common or they'll be changed with every channel name...?? Regards Deepak On Sun, Nov 20, 2011 at 2:43 PM, maulik desai mauliksde...@gmail.com wrote: Thanks you so much deepak for your effort sorry for late reply becasue i can not able to use Gmail from my office pc i check your file it is working very well just one thing i want to ask u that i want to add some email id on CC BCC can u please help in this that how can i do that. while data pasted to mail body , bottom line of table is not reflected . Request you to please look in small chnages revert Thnaks in Advance.. On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Here it is I developed this code on 2007 platform..I hope it'll work in 2003 as well... Sorry.. I couldn't attached the excel file with my previous post because I's in office at that time can't access to gmail over there... Regards Deepak On Tue, Nov 15, 2011 at 11:32 PM, maulik desai mauliksde...@gmail.com wrote: Hi deepu, Thanks you so much for your reply I have tried to paste the code in module but it not work properly request you to kindly provide me the excel sheet with your macro code but before you send me the file required small changes do not use K M column for Chennel name email address that is given just for information my actual database is from A to G request you to kindly change the macro code accordingly send it back for the other checks also if you want u can create the summary sheet with the help of macro paste it on sheet 2 also for name u can use Column H for the proper output.1 more thing i want to tell you that a have to send mail with our
$$Excel-Macros$$ Excel Books or classes
Excel Experts, Can any body suggest me how to learn MS Excel with VBA through referring some books with little bit of basic knowledge about excel. I will be grateful if u guide us to attend classes, if any. Currently, pursuing CA Final located in Bengalooru, karanataka. Have a nice week ahead and time. -- Yours, Hari. -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ text assignment to the textbox control
check if your textbox name is text1 you can attached your file in mail.. On Sat, Dec 10, 2011 at 9:17 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear experts Good morning, I am trying to assign a FIXED TEXT for a TEXTBOX1 Control in MSACCESS 2003. I have given a code line like: text1.text=Good Morning But it is not assigning the text given in strings. Pls suggest me how to assign a fixed text to a text box control. Thank you. -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Fwd: Vba Code for Outlook
Hi Guys, I am waiting for any response on below Vba query in Outlook. Request you to look into it and help me. Regards, Kaushik Savla -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: Sat, Dec 10, 2011 at 3:58 PM Subject: Vba Code for Outlook To: excel-macros@googlegroups.com Hi All, I am looking for solution to below:- I receive No. of emails from some people asking for tax advise. Then I create tax advice and I attach the file. I need to reply to the email received below:- Hi *Sender*(as per email), As requested, please find attached below payslip showing tax payable. (Attachment file would be here) Kindly let me know in case you require further information. Best Regards, Kaushik Savla - Assistant Manager JLT India Pvt Ltd What I want to do - Firstly, I want a code which will write the above green highlighted text message automatically. Secondly, I want Sender name to be captured automatically as per email received from sender. Please suggest me some solution. Your valuable time is highly appreciated in this matter. Regards, Kaushik Savla Mobile 7738 44 9292 -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Attendance Tracker
Hi All, Request you to please share, If you have any tool or tracker for Maintain the attendance for a Team of 15 People Thanks in advance -- Thanks Regards, Kiran -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Attendance Tracker
Google is your friend. I typed excel:attendance tracker and got this url http://tinyurl.com/79rzajm Don Guillett SalesAid Software dguille...@gmail.com From: Kiran Kancharla Sent: Sunday, December 11, 2011 9:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Attendance Tracker Hi All, Request you to please share, If you have any tool or tracker for Maintain the attendance for a Team of 15 People Thanks in advance -- Thanks Regards, Kiran -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: hi can you solve this
hi maries thank you very much On Dec 9, 5:12 pm, Maries talk2mar...@gmail.com wrote: Hi, Find the attached file. Regards, MARIES. On Fri, Dec 9, 2011 at 12:55 PM, Renukachari Kasee jva.ch...@gmail.comwrote: hi thanks for you valuble replay but i need like this can you see this attachment On 8 December 2011 18:56, Renukachari Kasee jva.ch...@gmail.com wrote: *(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪* * * *P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, reduce usage of plastics, and use renewable energy sources.* -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------ To post to this group, send email to excel-macros@googlegroups.com Solved+By+Maries+09.12.2011(1).xls 27KViewDownload- Hide quoted text - - Show quoted text - -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Excel Books or classes
I would say start topic wiseLearn each at a timelike, basics,formulas and functions, charts, pivot tables and then on to vba/ macros. You can start following any basic book about excel.. -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ How to use API in VBA
Hi,experts, I really want to study API in VBA,but i do not know how to do it. can you give me some advice? thanks -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ VBA code automatic typesetting and show code row number
Hi,dear experts, can anyone teach me how to automatic typesetting VBA code and row number? that's be great. Thanks -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Worksheet Function Requires Range object as parameter
Hello, I would like to use the Forecast worksheet function in an integration routine. It appears to require a Range object as the look up value, my code carries this value as a double. Is there a way to wrap the value into a Range object without having to reference the worksheet explicitly? Functions can't change the calling environment, so trying to just write the value to a cell fails -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Please help to convert tables from PDF to Excel.
Hello Pravesh: You can fully convert your PDF file into Excel file, with the format intact, using Cogniview's PDF2XL software. I was referred to it by my peer for my research work, and was easily able to extract data from almost any type of PDF - documents with different tables on different pages, documents with several tables on a single page, rotated pages, PDFs with tiny or unreadable fonts, PDFs with a combination of fields and tables - any type of PDF practically. I am giving below the link for your reference: http://www.cogniview.com/pdf2xl.php On Monday, 24 October 2011 16:46:01 UTC+5:30, pravesh verma wrote: Hi Group, please find 2 files in which below one is a pdf file, and it contain some tables, which i have to convert in excel , after googlng i am able to convert them in excel but still not fully converted, as all rows of pdf file come in one row in excel file as u can see in excel file, and i want each row separately , can you please help. in waiting -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Macro To Generate Tables with Statistical Calculations
Dear Friends, I have an excel data on first sheet with 4 columns and need to be generate tables on second sheet according to given format as below conditions. There should be 4 different tables on sheet named Table according to Priority (1-Critical, 2-Urgent, 3-Normal 4-Medium) There are two type of Data Classification (Incident Service Request) And in each table Count should be for both incident and service request but other all values (P50, P95, P75, Mean, Min, Max, Span and Tr.Mean) should be only for Incident. P50 is 50% Percentile P95 is 95% Percentile P75 is 75% Percentile Span is Difference of Max and Min (Span = Max - Min) Tr. Mean is TRIMMEAN 10% (For This I used formula as =TRIMMEAN(array, 0.1) Now My Problem is that I have to get tables according values in 4th Column Number On Second sheet all calculation should be according to Number 1 to 4 1 to 4 I have given as sample, It can be more I need a macro which will generate all 4 tables on second sheet according to priority and Number. Sample values I have given for Number 1 Please revert to me for any clarification. But I don't know How to attach Sample excel file here. Thanks! Regards, Atul -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com