New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

I need Help with sending emails_VBA reports

Macros, VBA, Excel Automation, etc.

I need Help with sending emails_VBA reports

Postby TonyC » Thu May 05, 2016 9:05 am

Dear Experts,

This report has more than a thousand entries, but i picked an example to show you.

I have hundreds of employee managers that need to be aware that their reps have no targets , but instead of having to contact each via outlook manually I need a VBA code to email via macro. Please see attached sheet for illustration.

1- I need for the (Supv Name) column to be filtered under each supervisor which in return filters for the applicable data related to each supervisor just as shown on the sheet – for EMP ID, name, Action , etc..
2- And once the superviser name is filtered with its corresponding data, I need it to be emailed (outlook)to that supervisor email listed under (supvEmail) column.

Thank you very much for your help
Tony
  • 0

You do not have the required permissions to view the files attached to this post.
Last edited by TonyC on Thu May 12, 2016 2:39 pm, edited 5 times in total.
TonyC
Rookie
 
Posts: 13
Joined: Dec 17, 2015
Reputation: 0
Excel Version: 2010

Re: Help with sending emails_VBA

Postby pecoflyer » Thu May 05, 2016 1:19 pm

Hello

in the future please be careful about which forum you post in.

You posted this one in " Tips and Tutorials" which is not intended for questions.

I moved it for you

Cheers
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Re: Help with sending emails_VBA

Postby TonyC » Thu May 05, 2016 2:06 pm

Absolutely...

Thank you
  • 0

TonyC
Rookie
 
Posts: 13
Joined: Dec 17, 2015
Reputation: 0
Excel Version: 2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 45 guests