Link Pivot to Mail
Closed
EDD
-
Mar 15, 2010 at 11:25 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 17, 2010 at 09:37 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 17, 2010 at 09:37 AM
Related:
- Link Pivot to Mail
- Windows live mail download - Download - Email
- Yahoo mail sign up - Guide
- Facebook unlock link - Facebook Forum
- Facebook unlock link needed urgently - Facebook Forum
- Yahoo mail - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 15, 2010 at 01:32 PM
Mar 15, 2010 at 01:32 PM
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 )
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
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
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 16, 2010 at 07:18 AM
Mar 16, 2010 at 07:18 AM
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
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
>
EDD
Mar 16, 2010 at 10:02 AM
Mar 16, 2010 at 10:02 AM
This is one, but I am sure there are few more so
https://ccm.net/forum/affich-279926-macro-to-email-when-a-cell-has-certain-value
https://ccm.net/forum/affich-279926-macro-to-email-when-a-cell-has-certain-value
Jay
>
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
Mar 16, 2010 at 10:29 AM
Mar 16, 2010 at 10:29 AM
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?
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?
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
>
Jay
Mar 16, 2010 at 10:33 AM
Mar 16, 2010 at 10:33 AM
Jay, where or how email address would be determined
jay
>
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
Mar 16, 2010 at 11:53 AM
Mar 16, 2010 at 11:53 AM
I have a set list of email addresses that the mail would go out to. that mailing list will not change .
