Send filtered range by e-mail (with total)

[mcoelho]

Hi everybody,

I've got quite a challenge. Every month I receive a huge file from the mobile phone company with the call details of every employee. Something like:

Phone number / Number dialed / Call date / Duration / Cost

I have to send every employee the details of his/her calls.

I'd like to have Excel do the following:
-Filter the range to find unique cell phone numbers and group them
-Create a total for the cost column (for each mobile phone number/group)
-Put this filter in an e-mail
-Send it to the e-mail of the phone number's owner

This would really be a time-saver.

Of course, I would have to have a worksheet with the mobile phone number and the owner's e-mail where the macro would find the corresponding e-mails.

I know there are tools to do this out there, namely http://www.rondebruin.nl/mail/folder3/row2.htm

but I can't insert a subtotal on the filtered range before collating it on the e-mail.

Can somebody please help?

Thanks a lot,
Regards
Miguel

 

[pbornemeier]

Create/Erase a temp worksheet.
Filter for a particular phone number.
Copy all visible rows to a temp worksheet.
Add the total row.
Send that worksheet.