Send to Email

[bruno2580]

Hi guys

I was just wondering is it possible to setup a button so when I click it I could send the contents of spreadsheet to a email and email it off.

I have a spreadsheet that tracks my works administration and it has 4 headings,

General,
Leave,
Pay and
Q Store.

In the past I have just copied and pasted what I need into outlook then emailed my report off Is it possible to make this auto


Emails I have to write are,

General,

Name - admin submitted

pay

Name - admin submitted

Q Store,

Name - admin submitted

leave,

Name - admin submitted

thanks in advance guys

[davsth]

Depending exactly what you want, this is always a good starting point when it comes to email from excel https://www.rondebruin.nl/win/s1/outlook/mail.htm

[davesexcel]

For this example enter something in G1 & H1, use this code

Please Login or Register  to view this content.

[Logit]

.
Are you sending the entire table (A6:H24) in your email ... or only a smaller section of the table ... or

Name - admin submitted

just these two columns ?

Are there four different email addresses you are sending to represented by :

General,
Leave,
Pay and
Q Store.

Or is it only one email address the data is being mailed to ?

[bruno2580]

So everyones admin gets submitted one after the other in the spreadsheet and it separated by the 4 options
General
Leave
Pay
Q Store
I send all this in one email but I only copy the persons name and the admin they submitted into the email so collum D and F

[Logit]

.
And do each of those individuals listed in F have a different email address or does the email go to only one email address ?

[bruno2580]

Hi

I send all the outstanding admin to the one email address.

I just separate the admin into the 4 options on the email as the spreadsheet is just compiled as admin comes in.

See attached outstanding Admin to chase up,

General,

Name - admin submitted

pay

Name - admin submitted

Q Store,

Name - admin submitted

leave,

Name - admin submitted

If there is no admin for any of the 4 headings then N/A goes there.