csaras84
09-08-2017, 05:18 AM
Hi Folks,
I have an excel with raw data (Autolink) of many columns. I have a code on another workbook which has a command button which when clicked invokes a code to add Sheet1 to the raw data workbook (Autolink), that includes only certain columns but also adds a new column where number of days are calculated based on a dates in other columns.
I have implemented the above but now what I want to do is this and finding it a tad bit difficult being a beginner.
1. Sheet1 needs to be filtered based on Column C (which includes Owner IDs).
2. For every owner ID, the selected range needs to be emailed to ownerID appended by the domain.
3. The range must be copied to the email body and not attached as an excel.
Can someone please help me on this?
Thank you in advance.
Saras
I have an excel with raw data (Autolink) of many columns. I have a code on another workbook which has a command button which when clicked invokes a code to add Sheet1 to the raw data workbook (Autolink), that includes only certain columns but also adds a new column where number of days are calculated based on a dates in other columns.
I have implemented the above but now what I want to do is this and finding it a tad bit difficult being a beginner.
1. Sheet1 needs to be filtered based on Column C (which includes Owner IDs).
2. For every owner ID, the selected range needs to be emailed to ownerID appended by the domain.
3. The range must be copied to the email body and not attached as an excel.
Can someone please help me on this?
Thank you in advance.
Saras