Answers.Body: <p>Yes you can do this with Views.</p>
  
  <p>Important points:</p>
  
  <ol>
  <li><p>Views must be configured to see the CiviCRM database in settings.php</p></li>
  <li><p>Create a View for "CiviCRM Activities".  "Bulk Mailing" is an Activity type</p></li>
  <li><p>The 'link' to view the bulk mailing is probably best constructed via "replacement patterns" within the Drupal View.  You get this link from the mailing itself, before it is sent.  All mailings have a similar link pattern, but each a unique number</p></li>
  <li><p>Create a Relationship in the view to the Drupal User.  Limit the results to the "current user" or the "logged in user".  I forget the precise wording.  This shows them "their mailings" - rather than everyone's mailings.</p></li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-10T01:03:58.983Z
Answers.Text: Thank you for the help. This worked. I created the view for "CiviCRM Mailings, constructed the link, set up the relationship and filter. And it worked. I now have a page with the list of mailings for that user. Yay! HOWEVER, when the user (me, testing, logged in to non-admin account) clicks on the link to the mailing, it says "access denied." These mailings were all set with visibility of "User and User Admin Only." Shouldn't the user be able to see these? I can see them in the list, but can't see the actual mailing. Strange...
Answers.UserDisplayName: The Amateur
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-10T01:31:41.897Z
Answers.Text: And a little research later I found this bug: "Mailing visibility doesn't work as described": https://issues.civicrm.org/jira/browse/CRM-14841 . So, basically, it's all for nought until that bug gets fixed. Well, at least that's my thinking at this point :-( Please correct me if I am wrong. Thanks again.
Answers.UserDisplayName: The Amateur
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-10T03:33:58.530Z
Answers.Text: Is it necessary to restrict mailings visibility to "user and admin"?  What if it was "public"?
Answers.UserDisplayName: CiviTeacher
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-10T22:30:48.880Z
Answers.Text: That would probably be fine, but I don't think I can change that visibility setting for past emails which is what I need to show the users.
Answers.UserDisplayName: The Amateur
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-11T00:09:44.820Z
Answers.Text: You can change visibility of past mailings, in bulk, in the civicrm_mailing table.  Backup your database first.
Answers.UserDisplayName: CiviTeacher
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-12T01:46:47.690Z
Answers.Text: Of course. I should have thought of that. Time to do some testing. Thanks again for all of your help.
Answers.UserDisplayName: The Amateur
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-09T00:10:52.977Z
Answers.LastActivityDate: 2015-11-09T00:10:52.977Z
Answers.UserDisplayName: CiviTeacher
Body: <p>I am using CiviCRM 4.6.x with Drupal 7.</p>
  
  <p>I would like users who are logged in to be able to see a table or list of all of the mailings they have been sent. The should be able to click on the subject line (or some other link) in the list in order to see the full text of that mailing.</p>
  
  <p>Can this be done and if so, how? In CiviCRM? With Views?</p>
  
  <p>Thanks for any suggestions.</p>
  
Tags: <civimail>
Title: How can I show users the mailings they have been sent?
ThreadText: # How can I show users the mailings they have been sent?
  
  (Asked by: username_0 on 2015-11-08)
  
  I am using CiviCRM 4.6.x with Drupal 7.
  
  I would like users who are logged in to be able to see a table or list of all of the mailings they have been sent. The should be able to click on the subject line (or some other link) in the list in order to see the full text of that mailing.
  
  Can this be done and if so, how? In CiviCRM? With Views?
  
  Thanks for any suggestions.
  
  **Tags:** civimail
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-11-09. Score: 5 | Accepted answer
  
  Yes you can do this with Views.
  
  Important points:
  
  1. Views must be configured to see the CiviCRM database in settings.php
  2. Create a View for "CiviCRM Activities". "Bulk Mailing" is an Activity type
  3. The 'link' to view the bulk mailing is probably best constructed via "replacement patterns" within the Drupal View. You get this link from the mailing itself, before it is sent. All mailings have a similar link pattern, but each a unique number
  4. Create a Relationship in the view to the Drupal User. Limit the results to the "current user" or the "logged in user". I forget the precise wording. This shows them "their mailings" - rather than everyone's mailings.
  
  > **Comments:**
  > **username_0**: Thank you for the help. This worked. I created the view for "CiviCRM Mailings, constructed the link, set up the relationship and filter. And it worked. I now have a page with the list of mailings for that user. Yay! HOWEVER, when the user (me, testing, logged in to non-admin account) clicks on the link to the mailing, it says "access denied." These mailings were all set with visibility of "User and User Admin Only." Shouldn't the user be able to see these? I can see them in the list, but can't see the actual mailing. Strange...  
  > **username_0**: And a little research later I found this bug: "Mailing visibility doesn't work as described": https://issues.civicrm.org/jira/browse/CRM-14841 . So, basically, it's all for nought until that bug gets fixed. Well, at least that's my thinking at this point :-( Please correct me if I am wrong. Thanks again.  
  > **username_1**: Is it necessary to restrict mailings visibility to "user and admin"?  What if it was "public"?  
  > **username_0**: That would probably be fine, but I don't think I can change that visibility setting for past emails which is what I need to show the users.  
  > **username_1**: You can change visibility of past mailings, in bulk, in the civicrm_mailing table.  Backup your database first.  
  > **username_0**: Of course. I should have thought of that. Time to do some testing. Thanks again for all of your help.  
  
  ---
  
  