1. Filter a column. Let?s say the column is ?Customer Name?.
2. Select and copy the results (all visible data).
3. Paste into new sheet. The name of a sheet will be its Customer Name.
4. Similarly filter all the customers and create their sheets with respective customer names.
Secondly I want another macro to do this:
For each customer mentioned above, open a new email in Outlook 2010, copy and paste the results (from above) in the body (don?t attach the file, but instead copy & paste the data) and fill the ?To?, ?Cc?, ?Subject? fields and then save each email in Drafts folder.
Question
Mazhar
In an excel sheet, I want a macro to do this:
1. Filter a column. Let?s say the column is ?Customer Name?.
2. Select and copy the results (all visible data).
3. Paste into new sheet. The name of a sheet will be its Customer Name.
4. Similarly filter all the customers and create their sheets with respective customer names.
Secondly I want another macro to do this:
For each customer mentioned above, open a new email in Outlook 2010, copy and paste the results (from above) in the body (don?t attach the file, but instead copy & paste the data) and fill the ?To?, ?Cc?, ?Subject? fields and then save each email in Drafts folder.
Please help, thanks!
Link to comment
Share on other sites
1 answer to this question
Recommended Posts