Link Pivot to Mail

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Anybody know I can auto link a Pivot Table from My Excel sheet into a email??

3 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
What you mean link pivot table to your mail? are you saying that you want to email pivot table?. If that is the case, from what I know, you need to email whole workbook on which pivot data rely on for its data (at least the data )
0
hey,

Basically I have a pivot table and i was wondering if there is a way or function i can create a macro button that auto preps my email as so the relevant individuals are sent the mail and the pivot table is copied onto the mail. I have managed to create a hyperlink to prep the mail with the relevant people but it looks pretty messy as it jst shows the list of people and their email adds in the excel spreadsheet. can i insert a nice simple button that i can click and it will populate the same mail with the relevant people?? Thx
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Send email via button is possible. However the issue is still you cannot simply send the pivot table. You can send the workbook. I recall not long ago a thread on same subject where the person wanted to send email with message and attachment
0
Ok great, il try and find that thread and figure out how to create the macro button. Any ideas when the thread was created or perhaps the title of it??
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768 > EDD
0
>
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020

Hi,

Thanks for that. I have taken a look over the thread and sadly I dont understand it, im not very computer literate. I jst want a macro button that on my worksheet which i can click and that will open up my email with a ready prepped mail to all the desired recipiants? can one do this, please?
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768 > Jay
Jay, where or how email address would be determined
0
>
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020

I have a set list of email addresses that the mail would go out to. that mailing list will not change .
0