Good Morning Everyone,
I am wondering if i can get some help on this issue.
Every night, at work, we send out an email to all the representatives. For this email we are manually typing in all the information. I am wondering how i can make it so that this is automatically set up.
This is the format of the email
Recipents: Eastgate text message (an outlook name for all the reps)
Subject: Nightly numbers
Body:
Eastgate
Rev: (Value from sheet, that changes cell depending on day)
WTD Rev: Standard for the week but changes once a week
H/S: (Value from sheet, that changes cell depending on day)
WTD H/S: Standard for the week but changes once a week
IPS: (Value from sheet, that changes cell depending on day)
WTD IPS: Standard for the week but changes once a week
Att Rate: (Value from sheet, that changes cell depending on day)
WTD Att Rate: Standard for the week but changes once a week
New Activations: Value from cell for that day
That is the email, now to make things more complicated, The info will change each day and each week from cells on the sheet that is manually entered each day
i had an idea, to make a cell Validation, with a list that includes Sunday through saturday, and another cell next to it, with week1 through 5, and whne someone selects sunday and week 1 it will provide the information from the cells i will go through and set up, (either an array or some other way) not too sure how yet though.
Then the email can be sent from the sheet that has the specific info on it.
If there is any help anyone can recommend, i would greatly appreciate it. Thank you all very much in advance.
Bookmarks