Hi, Can añy one would suggest ;
1. How to copy data from specific worksheeet . data range is dynamic meaning end row is varying but header row remain from m a1 to h1. 2. Paste data so copied in body of the email. Or copy data from excel , store it as image and then use some code to pull this imageto be part of email. Many thanks in advance; C.G. Kumar ---------- Forwarded message ---------- From: *C.G.Kumar* <kumar.bemlmum...@gmail.com> Date: Saturday, August 9, 2014 Subject: $$Excel-Macros$$ Include dynamic data range To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Attached is sample excel file used to remind customer in India to pay. Excel expert help and support is expected on the below concern to modify attached macro: 1. Once "Send EMail" button in cell N1 is clicked, it capture details well. But, before, mail is sent to customer , I need to go to sheet 2, filter by same customer code (active cell in sheet 1 and column B) and then copy entire rannge by selecting range, and paste data range at the bottom of e-mail and adding Title " Outstanding Dues". 2. How to add Cc and Bcc through macro. It is available in col K and L if available. 3. The macro run for one customer at a time . Can it be modified to run for range selected. Thanks in advance. -- 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 <javascript:_e(%7B%7D,'cvml','excel-macros%2bunsubscr...@googlegroups.com');> . To post to this group, send email to excel-macros@googlegroups.com <javascript:_e(%7B%7D,'cvml','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. -- 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.
Sending Reminder.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
