$$Excel-Macros$$ - Split Row
Hi Team, Problem Statement - I have an excel with multiple rows which contains data of employee-wise rent paid details for a date range. I need to split data in such a way that employee-wise monthly rent paid details are available. Please help. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/excel-macros/CA%2Bqfn8MJo6vKMO3f0%3DzOgPjvLODhYgssexBQYhkECOoEF9jTVQ%40mail.gmail.com.
Re: $$Excel-Macros$$ Finding Overlapping dates
Hi Team, Just wanted to check if you have found any solution. Regards Atuk On Wed, Apr 27, 2016 at 10:35 PM, Atul Kesaria <atul.kesa...@gmail.com> wrote: > Hello Team, > > I need a help to fit in a formula to find if there are any overlapping > dates for multiple date range. Please note that column can increase or > decrease. > > Attached is the sample spreadsheet. > > Thanking in advance. > > Regards > Atul > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, 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 unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Finding Overlapping dates
Hello Team, I need a help to fit in a formula to find if there are any overlapping dates for multiple date range. Please note that column can increase or decrease. Attached is the sample spreadsheet. Thanking in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$- Query
Hi Team, Can you help me to fix this small thing. Regards Atul On Sun, Mar 9, 2014 at 7:04 PM, Atul Kesaria atul.kesa...@gmail.com wrote: Hi Team, Thanks for the help. However just found one bug in macro. If the status is N in the AE column then the macro stops at that row and does not processed over to the next row even if the status is Y. Please help in solving that. Regards Atul On Mon, Feb 17, 2014 at 3:53 PM, mrExcel4u mr.exce...@gmail.com wrote: Hi Atul, PFA... Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Mon, Feb 17, 2014 at 1:15 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, Can some one help. Regards Atul On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, I need a help in creating a macro for attached sheet Process Brief:- 1) Need to send email to people based of status as per column AE. If status is Y: then mail should be send to people as per email ID To CC and attachement should be done based on file name in column AB, AC AD. 2) If the status isN no action required for that row. 3) I should be able to give the path where the files are stored. The file would in PDF format. Thanking you in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https
Re: $$Excel-Macros$$- Query
Hi Team, Thanks for the help. However just found one bug in macro. If the status is N in the AE column then the macro stops at that row and does not processed over to the next row even if the status is Y. Please help in solving that. Regards Atul On Mon, Feb 17, 2014 at 3:53 PM, mrExcel4u mr.exce...@gmail.com wrote: Hi Atul, PFA... Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Mon, Feb 17, 2014 at 1:15 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, Can some one help. Regards Atul On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, I need a help in creating a macro for attached sheet Process Brief:- 1) Need to send email to people based of status as per column AE. If status is Y: then mail should be send to people as per email ID To CC and attachement should be done based on file name in column AB, AC AD. 2) If the status isN no action required for that row. 3) I should be able to give the path where the files are stored. The file would in PDF format. Thanking you in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$- Query
Hi Team, Can some one help. Regards Atul On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, I need a help in creating a macro for attached sheet Process Brief:- 1) Need to send email to people based of status as per column AE. If status is Y: then mail should be send to people as per email ID To CC and attachement should be done based on file name in column AB, AC AD. 2) If the status isN no action required for that row. 3) I should be able to give the path where the files are stored. The file would in PDF format. Thanking you in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$- Query
Hi Team, I need a help in creating a macro for attached sheet Process Brief:- 1) Need to send email to people based of status as per column AE. If status is Y: then mail should be send to people as per email ID To CC and attachement should be done based on file name in column AB, AC AD. 2) If the status isN no action required for that row. 3) I should be able to give the path where the files are stored. The file would in PDF format. Thanking you in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. ABC .xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook
Hi Ashish, What I am looking at zipping respective PDF file as a seperate zip file and not all pdf files in one zip. Sorry but i could not see that in that link. Regards Atul On Thu, Feb 6, 2014 at 12:56 PM, ashish koul koul.ash...@gmail.com wrote: check this http://www.rondebruin.nl/win/s7/win001.htm http://www.rondebruin.nl/win/section7.htm On Tue, Feb 4, 2014 at 8:31 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Ashish, One more help to earlier macro. Is there a way we can put password to the PDF file or make a zip file of respective pdf file with a password and then email. Password can be predefined to either date of birth or anything else which would be incorporated in the excel file. Regards Atul On Mon, Feb 3, 2014 at 1:25 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Thanks Ashishreally helpfull... On Mon, Feb 3, 2014 at 10:50 AM, ashish koul koul.ash...@gmail.comwrote: try this Set Mailrng = Sheets(Sheet1).Range(c2:c Sheets(Sheet1).Range(c1).End(xlDown).Row) On Mon, Feb 3, 2014 at 12:28 AM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Ashish, You are rockstar. Just one last help. Can the range be set a dynamic rather than staticas the range will vary from time to time. Regards Atul On Sun, Feb 2, 2014 at 9:50 PM, ashish koul koul.ash...@gmail.comwrote: Sub test() Dim mailrng As Range Dim cl As Range Dim fl_path As String Set mailrng = Sheets(Sheet1).Range(c2:c5) For Each cl In mailrng Call sendmail(cl.Value, cl.Offset(0, -1).Value, cl.Offset(0, 1)) Next End Sub Sub sendmail(mailid As String, nm As String, flname As String) Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject(Outlook.Application) Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .to = mailid .Subject = Hello! .Body = Dear nm , vbNewLine vbNewLine HELLO ! vbNewLine vbNewLine Thank you .Attachments.Add C:\Documents and Settings\Ashish Koul\Desktop\fb page problem\ flname .XLSX .display 'or use .send End With On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub On Sun, Feb 2, 2014 at 6:23 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, Any luck of my earlier mail. Regards Atul On Sat, Feb 1, 2014 at 10:34 PM, Atul Kesaria atul.kesa...@gmail.com wrote: Hi PFA fileplease note that the attachment which need to go with each mail would be a PDF file. On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria atul.kesa...@gmail.com wrote: PFA On Sat, Feb 1, 2014 at 7:45 PM, ashish koul koul.ash...@gmail.com wrote: please share a sample file On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria atul.kesa...@gmail.com wrote: Hi Team, I need a help in getting a macro which will help sending email with attachment to list of person in the excel sheet which will have there Name, email ID,Unique number. Please note that every person should receive a particular file based on their unique number. File are prestored in a particular location with a unique number mention in the excel sheet. The subject line and body on the email will remain same. Thanking in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out . -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebookhttp://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles
Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook
Hi Ashish, One more help to earlier macro. Is there a way we can put password to the PDF file or make a zip file of respective pdf file with a password and then email. Password can be predefined to either date of birth or anything else which would be incorporated in the excel file. Regards Atul On Mon, Feb 3, 2014 at 1:25 PM, Atul Kesaria atul.kesa...@gmail.com wrote: Thanks Ashishreally helpfull... On Mon, Feb 3, 2014 at 10:50 AM, ashish koul koul.ash...@gmail.comwrote: try this Set Mailrng = Sheets(Sheet1).Range(c2:c Sheets(Sheet1).Range(c1).End(xlDown).Row) On Mon, Feb 3, 2014 at 12:28 AM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Ashish, You are rockstar. Just one last help. Can the range be set a dynamic rather than staticas the range will vary from time to time. Regards Atul On Sun, Feb 2, 2014 at 9:50 PM, ashish koul koul.ash...@gmail.comwrote: Sub test() Dim mailrng As Range Dim cl As Range Dim fl_path As String Set mailrng = Sheets(Sheet1).Range(c2:c5) For Each cl In mailrng Call sendmail(cl.Value, cl.Offset(0, -1).Value, cl.Offset(0, 1)) Next End Sub Sub sendmail(mailid As String, nm As String, flname As String) Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject(Outlook.Application) Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .to = mailid .Subject = Hello! .Body = Dear nm , vbNewLine vbNewLine HELLO ! vbNewLine vbNewLine Thank you .Attachments.Add C:\Documents and Settings\Ashish Koul\Desktop\fb page problem\ flname .XLSX .display 'or use .send End With On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub On Sun, Feb 2, 2014 at 6:23 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, Any luck of my earlier mail. Regards Atul On Sat, Feb 1, 2014 at 10:34 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi PFA fileplease note that the attachment which need to go with each mail would be a PDF file. On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria atul.kesa...@gmail.com wrote: PFA On Sat, Feb 1, 2014 at 7:45 PM, ashish koul koul.ash...@gmail.comwrote: please share a sample file On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria atul.kesa...@gmail.com wrote: Hi Team, I need a help in getting a macro which will help sending email with attachment to list of person in the excel sheet which will have there Name, email ID,Unique number. Please note that every person should receive a particular file based on their unique number. File are prestored in a particular location with a unique number mention in the excel sheet. The subject line and body on the email will remain same. Thanking in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebookhttp://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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
Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook
Hi Team, Any luck of my earlier mail. Regards Atul On Sat, Feb 1, 2014 at 10:34 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi PFA fileplease note that the attachment which need to go with each mail would be a PDF file. On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria atul.kesa...@gmail.comwrote: PFA On Sat, Feb 1, 2014 at 7:45 PM, ashish koul koul.ash...@gmail.comwrote: please share a sample file On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, I need a help in getting a macro which will help sending email with attachment to list of person in the excel sheet which will have there Name, email ID,Unique number. Please note that every person should receive a particular file based on their unique number. File are prestored in a particular location with a unique number mention in the excel sheet. The subject line and body on the email will remain same. Thanking in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups
Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook
Hi Ashish, You are rockstar. Just one last help. Can the range be set a dynamic rather than staticas the range will vary from time to time. Regards Atul On Sun, Feb 2, 2014 at 9:50 PM, ashish koul koul.ash...@gmail.com wrote: Sub test() Dim mailrng As Range Dim cl As Range Dim fl_path As String Set mailrng = Sheets(Sheet1).Range(c2:c5) For Each cl In mailrng Call sendmail(cl.Value, cl.Offset(0, -1).Value, cl.Offset(0, 1)) Next End Sub Sub sendmail(mailid As String, nm As String, flname As String) Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject(Outlook.Application) Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .to = mailid .Subject = Hello! .Body = Dear nm , vbNewLine vbNewLine HELLO ! vbNewLine vbNewLine Thank you .Attachments.Add C:\Documents and Settings\Ashish Koul\Desktop\fb page problem\ flname .XLSX .display 'or use .send End With On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub On Sun, Feb 2, 2014 at 6:23 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, Any luck of my earlier mail. Regards Atul On Sat, Feb 1, 2014 at 10:34 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi PFA fileplease note that the attachment which need to go with each mail would be a PDF file. On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria atul.kesa...@gmail.comwrote: PFA On Sat, Feb 1, 2014 at 7:45 PM, ashish koul koul.ash...@gmail.comwrote: please share a sample file On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, I need a help in getting a macro which will help sending email with attachment to list of person in the excel sheet which will have there Name, email ID,Unique number. Please note that every person should receive a particular file based on their unique number. File are prestored in a particular location with a unique number mention in the excel sheet. The subject line and body on the email will remain same. Thanking in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official
Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook
Thanks Ashishreally helpfull... On Mon, Feb 3, 2014 at 10:50 AM, ashish koul koul.ash...@gmail.com wrote: try this Set Mailrng = Sheets(Sheet1).Range(c2:c Sheets(Sheet1).Range(c1).End(xlDown).Row) On Mon, Feb 3, 2014 at 12:28 AM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Ashish, You are rockstar. Just one last help. Can the range be set a dynamic rather than staticas the range will vary from time to time. Regards Atul On Sun, Feb 2, 2014 at 9:50 PM, ashish koul koul.ash...@gmail.comwrote: Sub test() Dim mailrng As Range Dim cl As Range Dim fl_path As String Set mailrng = Sheets(Sheet1).Range(c2:c5) For Each cl In mailrng Call sendmail(cl.Value, cl.Offset(0, -1).Value, cl.Offset(0, 1)) Next End Sub Sub sendmail(mailid As String, nm As String, flname As String) Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject(Outlook.Application) Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .to = mailid .Subject = Hello! .Body = Dear nm , vbNewLine vbNewLine HELLO ! vbNewLine vbNewLine Thank you .Attachments.Add C:\Documents and Settings\Ashish Koul\Desktop\fb page problem\ flname .XLSX .display 'or use .send End With On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub On Sun, Feb 2, 2014 at 6:23 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, Any luck of my earlier mail. Regards Atul On Sat, Feb 1, 2014 at 10:34 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi PFA fileplease note that the attachment which need to go with each mail would be a PDF file. On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria atul.kesa...@gmail.comwrote: PFA On Sat, Feb 1, 2014 at 7:45 PM, ashish koul koul.ash...@gmail.comwrote: please share a sample file On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria atul.kesa...@gmail.com wrote: Hi Team, I need a help in getting a macro which will help sending email with attachment to list of person in the excel sheet which will have there Name, email ID,Unique number. Please note that every person should receive a particular file based on their unique number. File are prestored in a particular location with a unique number mention in the excel sheet. The subject line and body on the email will remain same. Thanking in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebookhttp://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group
Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook
PFA On Sat, Feb 1, 2014 at 7:45 PM, ashish koul koul.ash...@gmail.com wrote: please share a sample file On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, I need a help in getting a macro which will help sending email with attachment to list of person in the excel sheet which will have there Name, email ID,Unique number. Please note that every person should receive a particular file based on their unique number. File are prestored in a particular location with a unique number mention in the excel sheet. The subject line and body on the email will remain same. Thanking in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. sample.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook
Hi PFA fileplease note that the attachment which need to go with each mail would be a PDF file. On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria atul.kesa...@gmail.comwrote: PFA On Sat, Feb 1, 2014 at 7:45 PM, ashish koul koul.ash...@gmail.com wrote: please share a sample file On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, I need a help in getting a macro which will help sending email with attachment to list of person in the excel sheet which will have there Name, email ID,Unique number. Please note that every person should receive a particular file based on their unique number. File are prestored in a particular location with a unique number mention in the excel sheet. The subject line and body on the email will remain same. Thanking in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. sample.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Macro to Mail Merge from Excel Sheet
Hello Expert, Couple of reason for having a macro1) Data runs into more then 1000 rows 2) There are two many Format to which mail merge would be required. On Tue, Jun 11, 2013 at 7:18 PM, VBA VABZ v...@vabs.in wrote: This can be done using Mail Merge in word only. Refer link here: http://www.timeatlas.com/5_minute_tips/chunkers/mail_merge_tutorial_using_microsoft_word_and_excel#.Ubcqfvn7AqI Thanks On Tue, Jun 11, 2013 at 7:15 PM, VBA VABZ v...@vabs.in wrote: Hi, Why you need output in word? On Tue, Jun 11, 2013 at 7:09 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hello Expert, I need a help in creating a macro which will pick data from excel sheet to mail merge to a predefined Word template.Attached is a sample word Excel Format. Request your expert opinion in this regards. Cheers Atul Kesaria -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Macro to send Multiple file via Email
Hello Team, I need a macro which can send multiple file to individual person. For eg. If 1 folder has files basis name of person for year 1 2 folder has files basis name of peron for Year 2 then macro should send both this files. Please help. Thanks and Regards Atul Kesaria -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Help on Chart
Hello Team, I am preparing chart basis certain data. However wanted to check some way to prepare the chart only on the data which reflect in the excel sheet post i do a filter. So as soon as I change the filter the chart should change. Do let me know if that can be done. Cheers Atul -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Help on Chart
Hi Rajan, I would be doing filter not on the pivot table...but on the data in the sheet 1 which should reflect in the chart and the table. Cheers Atul On 7/7/11, Rajan_Verma rajanverma1...@gmail.com wrote: Hi, It's a pivot chart in your sheets its taking references from Pivot Table , when you will apply filter in Pivot table it will Show Only Filter Summary Data, -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Atul Kesaria Sent: Thursday, July 07, 2011 1:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help on Chart Hello Team, I think i was not very clear on my request. Please find attached excel sheet in which there is main data on sheet 1 and on the basis of which I have prepare chart on sheet 6. What I want is as soon as set a filter on Sheet 1 the chart on sheet 6 should be refreshed. Cheers Atul On 7/7/11, Rajan_Verma rajanverma1...@gmail.com wrote: See if it help -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Atul Kesaria Sent: Thursday, July 07, 2011 12:11 PM To: excel-macros Cc: atul.kesaria Subject: $$Excel-Macros$$ Help on Chart Hello Team, I am preparing chart basis certain data. However wanted to check some way to prepare the chart only on the data which reflect in the excel sheet post i do a filter. So as soon as I change the filter the chart should change. Do let me know if that can be done. Cheers Atul -- -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$
Hello Team, I need a macro code to add a row based on certain value in particular row. So for eg if A1=50 then add a row below A1 and copy the above data in the added row, a2=100 then no need to add row move on to next row ...if a3=50 then add row below that and so on till the last row. Thanks and Regards Atul Kesaria -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$-Macro to Prepare Letters
Hello Team, I am using macro for mail merge and wanna know how to make changes in font type and how to bold a particular line/word while doing mail merge. Can you please help me. Thanks and Regards Atul Kesaria -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$-Macro to Prepare Letters
Hello Team, I am using macro for mail merge and wanna know how to make changes in font type and how to bold a particular line/word while doing mail merge. Can you please help me. Thanks and Regards Atul Kesaria -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$-Macro to Prepare Letters
Hello Team, Please help me. Thanks and Regards Atul Kesaria On Fri, May 21, 2010 at 9:35 AM, Atul Kesaria atul.kesa...@gmail.comwrote: Hello Team, I am using macro for mail merge and wanna know how to make changes in font type and how to bold a particular line/word while doing mail merge. Can you please help me. Thanks and Regards Atul Kesaria -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$-Macro to Prepare Letters
Hello Team, I am using macro for mail merge and wanna know how to make changes in font type and how to bold a particular line/word while doing mail merge Thanks and Regards Atul Kesaria On Wed, May 12, 2010 at 11:18 PM, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: FYI -- Forwarded message -- From: Harpreet Singh Gujral harpreetguj...@gmail.com Date: Wed, May 12, 2010 at 11:04 PM Subject: Re: $$Excel-Macros$$-Macro to Prepare Letters To: Atul Kesaria atul.kesa...@gmail.com Atul, I had a look at ur problem and researched over it. As per me, or my understanding of the information available on the internet, its better to open Word and use Mail merge feature. You can read some stuff on the following: http://www.ozgrid.com/forum/showthread.php?t=30692 But, there could be a solution to it..If i leave mail merge feature on the side While writing this email it came to my mind, why dont we bring the letter format to Excel. See Sheet2 in the attached workbook If the idea looks reasonable, i can create a look to go through all the records in Sheet1 [One by one], it will paste the data in Sheet 2 and print a letter. This was you can print all your letters at a click of a button Let me know, if you think this is a good idea Harry On Wed, May 12, 2010 at 4:21 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hello Harry, You can use the same file which i have send u earlier as the actual data and the letter format preparation is under process. I would try to modify your macro to my need and of course need-less to say would take your help if I am not able to do it myself. Thanks and Regards Atul Kesaria On Wed, May 12, 2010 at 3:02 PM, Harpreet Gujral harpreetguj...@gmail.com wrote: Yeah, got your point This means, you have a single formatted letter with fields from the excel sheet. You want letters to be generated for all the records in excel. Can you send the letter and a sample data, 4-5 records would do. I would have a look at it Harry Sent on my BlackBerry® from Vodafone Essar -- *From: *Atul Kesaria atul.kesa...@gmail.com *Date: *Wed, 12 May 2010 14:40:41 +0530 *To: *harpreetguj...@gmail.com *Subject: *Re: $$Excel-Macros$$-Macro to Prepare Letters Hello Harry, The excel sheet is just a format, my file include other heads instead of address, it would include salary numbers, department name, employee ID etc Basically I am looking at capturing all the field of that particular row in one letter at the predefined place. So one letter for each row item. I hope I am able to clear your doubt. Thanks and Regards Atul Kesaria On Wed, May 12, 2010 at 9:55 AM, Harpreet Gujral harpreetguj...@gmail.com wrote: I had a quick look on what you want to do. Of what I understand is, you pick up addresses from the excel sheet and you want to use a word doc as a format. There could be two things: 1) You want to print a single letter for the whole list in the excel or 2) You want to use a letter format depending upon a criteria. Eg: if 2nd row on excel does not meet a criteria then use 2nd format of the letter I hope I am able to make clear my doubt If you can provide some clarification on the above two points, then may be I am able to help you out Harry Sent on my BlackBerry® from Vodafone Essar -- *From: *Atul Kesaria atul.kesa...@gmail.com *Date: *Wed, 12 May 2010 09:05:55 +0530 *To: *Harpreet Singh Gujralharpreetguj...@gmail.com *Subject: *Re: $$Excel-Macros$$-Macro to Prepare Letters Hello Harry, I mean i can use different macro for preparing different format of letters. It is not necessary that macro should pick up a particular format of letter and then print it. Are you going built the format within the macro or you would link to predefine letter format. I have got one macro but it does not work. Attached is the macro in text file and the excel sheet which need to saved on c drive so that macro picks up the data from the said path. Thanks and Regards Atul Kesaria On Wed, May 12, 2010 at 7:24 AM, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Atul, So you mean, that you need to use different format of a letter, basis on some condition. Is that correct? If the answer is yes, please provide a condition on how you want to select a particular letter and mail it Harry On May 11, 3:54 pm, Atul Kesaria atul.kesa...@gmail.com wrote: Hello Team, Can some one please help me. Thanks and Regards Atul Kesaria On Sun, May 9, 2010 at 6:20 PM, Atul Kesaria atul.kesa...@gmail.com wrote: Hello Andy, I can use mail merge, but thats a manual process and I want to use different format for for preparing letters which might go above 1000+ letter. Thge problem using mail merge manually is that it again require formatting and whicd adds up to more time
Re: $$Excel-Macros$$-Macro to Prepare Letters
Hello Team, Can some one please help me. Thanks and Regards Atul Kesaria On Sun, May 9, 2010 at 6:20 PM, Atul Kesaria atul.kesa...@gmail.com wrote: Hello Andy, I can use mail merge, but thats a manual process and I want to use different format for for preparing letters which might go above 1000+ letter. Thge problem using mail merge manually is that it again require formatting and whicd adds up to more time in preparing letters. Looking forwad for the help. Thanks and Regards Atul Kesaria On 5/7/10, Aindril De aind...@gmail.com wrote: Hi atul, Why dont u use mail merge. Regards, Andy On Fri, May 7, 2010 at 12:38 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hello Team, I am looking at a macro to write letter in word (a predefine letter format) with certain field to be picked from an excel-sheet source. Request you to send me macro code. Thanks and Regards Atul Kesaria -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$-Macro to Prepare Letters
Hello Andy, I can use mail merge, but thats a manual process and I want to use different format for for preparing letters which might go above 1000+ letter. Thge problem using mail merge manually is that it again require formatting and whicd adds up to more time in preparing letters. Looking forwad for the help. Thanks and Regards Atul Kesaria On 5/7/10, Aindril De aind...@gmail.com wrote: Hi atul, Why dont u use mail merge. Regards, Andy On Fri, May 7, 2010 at 12:38 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hello Team, I am looking at a macro to write letter in word (a predefine letter format) with certain field to be picked from an excel-sheet source. Request you to send me macro code. Thanks and Regards Atul Kesaria -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$-Macro to Prepare Letters
Hello Team, I am looking at a macro to write letter in word (a predefine letter format) with certain field to be picked from an excel-sheet source. Request you to send me macro code. Thanks and Regards Atul Kesaria -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: VLookup formula
Hello Suresh, Please find the attached sheet, hope this is what you are looking for. Thanks and Regards Atul Kesaria On Thu, Jul 16, 2009 at 1:29 PM, Ayushj jainayus...@gmail.com wrote: Dear Members, Can anyone assist Suresh on his query ? Thank you. On Jul 16, 12:57 pm, suresh k brave.sur...@gmail.com wrote: Hi I have one query. I have data in two different sheets. Below are example for you. *Data in sheet 1:* Name Data Date No. Su 12 1/1/99 123 gu 22 2/2/99 124 gg 33 3/3/00125 *Data in shee 2:* Name Data Date No. Su 12 1/1/99 123 ff 22 2/2/99 124 gg 33 3/3/00125 Now I need formula where i need to compare only first 2 columns (Name Data) and i need to findout how many line items are same. Please let me know if any one can help me on this. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- sample.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: VLookup formula
Sorry, Please find the revised file On Thu, Jul 16, 2009 at 2:27 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hello Suresh, Please find the attached sheet, hope this is what you are looking for. Thanks and Regards Atul Kesaria On Thu, Jul 16, 2009 at 1:29 PM, Ayushj jainayus...@gmail.com wrote: Dear Members, Can anyone assist Suresh on his query ? Thank you. On Jul 16, 12:57 pm, suresh k brave.sur...@gmail.com wrote: Hi I have one query. I have data in two different sheets. Below are example for you. *Data in sheet 1:* Name Data Date No. Su 12 1/1/99 123 gu 22 2/2/99 124 gg 33 3/3/00125 *Data in shee 2:* Name Data Date No. Su 12 1/1/99 123 ff 22 2/2/99 124 gg 33 3/3/00125 Now I need formula where i need to compare only first 2 columns (Name Data) and i need to findout how many line items are same. Please let me know if any one can help me on this. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- sample.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Enable Selection to Unlocked Cells only
Hello Ashish, Can you help me to do the same in office 2007. new to 2007 hence need help. Thanks and Regards Atul Kesaria On Tue, Jul 7, 2009 at 11:45 AM, Ashish Pradhan ashlyprad...@gmail.comwrote: Hi All Not sending this tip in the best tip for the week format as this is not my original idea but nevertheless a useful tip In a protected worksheet, a user may want to navigate only to those cells which are unlocked. i.e., Navigation should not be allowed to those cells which have formula (for example). Navigation should be allowed only to cells where a user can input data. To do this: To make cells unselectable, change the worksheet's EnableSelection property. Select *View, Toolbars, Control Toolbox* to display the Control Toolbox toolbar. Click the Properties button to display the Properties box for the worksheet, then click the cell labeled xlNoRestrictions and use the drop-down list to change the EnableSelection property to * xlUnlockedCells.* Close the Properties box. As long as the worksheet is protected, users cannot select the locked cells on the worksheet. Be sure to close the *Control Toolbox *toolbar once u are done. -- Ashish Of what use is freedom if it does not include the freedom to make mistakes -- Mahatma Gandhi --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Formula needed
Hello Venkat, Can you provide me with the excel sheet? Or against correponding code in second sheet. Apply formula =SUMIF('Sheet1'!(range of your data)'(code name cell number) Thanks and Regards Atul Kesaria On Wed, May 27, 2009 at 9:19 AM, venkat sudhakar sudhakar...@gmail.comwrote: Dear Friends, I need a formula for my work. There will be 2 Excel sheets. In First Sheet there will be 2 Columns In First column there will be code and in 2nd column there will be value and 'n' number of rows will be there. And the code may be repeated at several times in different rows. And in second sheet also, there will be 2 columns In first column there will be code. Now what i need is, against each item code in second sheet, the sum of values in first sheet representing corresponding code. Can any one do the needful. Regards, Venkat --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: $$Excel-Macros$$
Hello Dave, One small issue in the macro, the cell number b2 in the formula remain the same across all the row when we run the macro, however it should changes as the row changes. Please help. Thanks and Regards Atul Kesaria On Wed, May 27, 2009 at 11:11 AM, Atul Kesaria atul.kesa...@gmail.comwrote: Hello Dave, You are a rock Star...thanks a ton!!! The macro is awesome.this is what i wanted. Thanks and Regards Atul Kesaria On Wed, May 27, 2009 at 10:10 AM, Dave Bonallack davebonall...@hotmail.com wrote: Hi Atul, Have a look at the attached workbook, and see if it does what you want. I've added a button to run the macro from the sheet, but you may want to run it some other way. I've left your formulas as you had them. Regards - Dave. -- Date: Tue, 26 May 2009 18:33:57 +0530 Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ From: atul.kesa...@gmail.com To: excel-macros@googlegroups.com Hello Dave, Thanks for the below formulas. The reason I am asking for the macro is that we have more then 25 sheet in a file and more then 200 line items in each sheet, macro would help to reduce the file size and minimize the changes of error. I have attached a file in which i have tried to write a macro. Two things that i am unable to add. 1 )The macro should able to apply the formula till the last line 2) It should copy and paste special value all the formula applied. Thanking you once again in advance. Thanks and Regards Atul Kesaria On Tue, May 26, 2009 at 2:47 PM, Dave Bonallack davebonall...@hotmail.com wrote: Hi Atul, Just as a by-the-way, those formulas are much longer than needed. There are lots of redundant parts. The following would do the same thing: =IF(AND(B20,B2=1,0),1%,IF(b2=2,3%,IF(b2=3,5%,IF(b2=4,7.5%,IF(b2=5,8%,IF(b2=6,10%,0)) =IF(AND(b20,b2=1,0),11%,IF(b2=2,13%,IF(b2=3,15%,IF(b2=4,17.5%,IF(b2=5,18%,IF(b2=6,20%,0)) =IF(AND(b20,b2=1,0),21%,IF(b2=2,23%,IF(b2=3,25%,IF(b2=4,27.5%,IF(b2=5,28%,IF(b2=6,20%,0)) A multiple IF statement stops when it finds the first true statement, so you don't need to define the lower level of each range. Also, this sort of thing is done better using a table with VLOOKUP. You can change the values more easily, and the formulas are much simpler. As to a macro, if no one else answers, I could provide you with that. Regards - Dave. -- Check out the new Windows Live Messenger Looking for a fresh way to share your photos? http://windowslive.ninemsn.com.au/article.aspx?id=792335 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: $$Excel-Macros$$
Hello Dave, Thanks for the below formulas. The reason I am asking for the macro is that we have more then 25 sheet in a file and more then 200 line items in each sheet, macro would help to reduce the file size and minimize the changes of error. I have attached a file in which i have tried to write a macro. Two things that i am unable to add. 1 )The macro should able to apply the formula till the last line 2) It should copy and paste special value all the formula applied. Thanking you once again in advance. Thanks and Regards Atul Kesaria On Tue, May 26, 2009 at 2:47 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Atul, Just as a by-the-way, those formulas are much longer than needed. There are lots of redundant parts. The following would do the same thing: =IF(AND(B20,B2=1,0),1%,IF(b2=2,3%,IF(b2=3,5%,IF(b2=4,7.5%,IF(b2=5,8%,IF(b2=6,10%,0)) =IF(AND(b20,b2=1,0),11%,IF(b2=2,13%,IF(b2=3,15%,IF(b2=4,17.5%,IF(b2=5,18%,IF(b2=6,20%,0)) =IF(AND(b20,b2=1,0),21%,IF(b2=2,23%,IF(b2=3,25%,IF(b2=4,27.5%,IF(b2=5,28%,IF(b2=6,20%,0)) A multiple IF statement stops when it finds the first true statement, so you don't need to define the lower level of each range. Also, this sort of thing is done better using a table with VLOOKUP. You can change the values more easily, and the formulas are much simpler. As to a macro, if no one else answers, I could provide you with that. Regards - Dave. -- Check out the new Windows Live Messenger Looking for a fresh way to share your photos? http://windowslive.ninemsn.com.au/article.aspx?id=792335 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- SAMPLE.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Help on Macro-Atul
Hello Guys, Need a help on writing macro. I am preparing a sheet which has three coloumn. The first coloumn would have number ranging from 1 to 3. The Second coloumn would have certain number varying from 0 to 6( inclusive of demical to 2 digit).What I need in third coloumn is a formula which is based on value in coloumn first. For eg. If coloumn first has 1 then formula would be =IF(AND(B20,B2=1,0),1%,IF(AND(ROUND(b2=1.1,0),ROUND(b2=2,0)),3%,IF(AND(ROUND(b2=2.1,0),ROUND(b2=3,0)),5%,IF(AND(ROUND(b2=3.1,0),ROUND(b2=4,0)),7.5%,IF(AND(ROUND(b2=4.1,0),ROUND(b2=5,0)),8%,IF(AND(ROUND(b2=5.1,0),ROUND(b2=6,0)),10%,0)) If coloumn first has 2 then formula would be =IF(AND(b20,b2=1,0),11%,IF(AND(ROUND(b2=1.1,0),ROUND(b2=2,0)),13%,IF(AND(ROUND(b2=2.1,0),ROUND(b2=3,0)),15%,IF(AND(ROUND(b2=3.1,0),ROUND(b2=4,0)),17.5%,IF(AND(ROUND(b2=4.1,0),ROUND(b2=5,0)),18%,IF(AND(ROUND(b2=5.1,0),ROUND(b2=6,0)),20%,0)) If coloumn first has 3 then formula would be =IF(AND(b20,b2=1,0),21%,IF(AND(ROUND(b2=1.1,0),ROUND(b2=2,0)),23%,IF(AND(ROUND(b2=2.1,0),ROUND(b2=3,0)),25%,IF(AND(ROUND(b2=3.1,0),ROUND(b2=4,0)),27.5%,IF(AND(ROUND(b2=4.1,0),ROUND(b2=5,0)),28%,IF(AND(ROUND(b2=5.1,0),ROUND(b2=6,0)),20%,0)) The number of rows are not fixed and hence the macro should be able to run till the last record in that coloumn. It would be great if some one can provide me with a macro for the same. Thanks and Regards Atul Kesaria --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Help on Macro-Atul
Hello Guys, Need a help on writing macro. I am preparing a sheet which has three coloumn. The first coloumn would have number ranging from 1 to 3. The Second coloumn would have certain number varying from 0 to 6( inclusive of demical to 2 digit).What I need in third coloumn is a formula which is based on value in coloumn first. For eg. If coloumn first has 1 then formula would be =IF(AND(B20,B2=1,0),1%,IF(AND(ROUND(b2=1.1,0),ROUND(b2=2,0)),3%,IF(AND(ROUND(b2=2.1,0),ROUND(b2=3,0)),5%,IF(AND(ROUND(b2=3.1,0),ROUND(b2=4,0)),7.5%,IF(AND(ROUND(b2=4.1,0),ROUND(b2=5,0)),8%,IF(AND(ROUND(b2=5.1,0),ROUND(b2=6,0)),10%,0)) If coloumn first has 2 then formula would be =IF(AND(b20,b2=1,0),11%,IF(AND(ROUND(b2=1.1,0),ROUND(b2=2,0)),13%,IF(AND(ROUND(b2=2.1,0),ROUND(b2=3,0)),15%,IF(AND(ROUND(b2=3.1,0),ROUND(b2=4,0)),17.5%,IF(AND(ROUND(b2=4.1,0),ROUND(b2=5,0)),18%,IF(AND(ROUND(b2=5.1,0),ROUND(b2=6,0)),20%,0)) If coloumn first has 3 then formula would be =IF(AND(b20,b2=1,0),21%,IF(AND(ROUND(b2=1.1,0),ROUND(b2=2,0)),23%,IF(AND(ROUND(b2=2.1,0),ROUND(b2=3,0)),25%,IF(AND(ROUND(b2=3.1,0),ROUND(b2=4,0)),27.5%,IF(AND(ROUND(b2=4.1,0),ROUND(b2=5,0)),28%,IF(AND(ROUND(b2=5.1,0),ROUND(b2=6,0)),20%,0)) The number of rows are not fixed and hence the macro should be able to run till the last record in that coloumn. It would be great if some one can provide me with a macro for the same. Thanks and Regards Atul Kesaria --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need Help regarding split Emp. Name Emp. ID
Lavprasad Kori- If you add trim function for the name it would remove any additional unwanted space On Mon, Apr 13, 2009 at 7:42 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: attached file has the solution assuming that ID will be of 5 digits only On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori lavprasa...@gmail.comwrote: Dear Friends, I am downloading the employee data from our portal. In, there is employee name Emp. ID both are in the same column. I want to split Emp. Name Emp. ID in to two different column. I am also attaching the reference file. Please help me. Thanks in advance. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---