Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Export a list of mail recipients from Lotus Notes

Posted on 2012-03-30
6
Medium Priority
?
671 Views
Last Modified: 2013-12-18
Hey Experts,

I need a way to dump a list of everyone that was sent mail from a mail database.

Does anyone have any ideas on how this can be accomplished?

Many Thanks!!
0
Comment
Question by:Marv1n
6 Comments
 
LVL 7

Expert Comment

by:Sam654
ID: 37789354
One option would be to create a view in the database and have the first column display the contents of the To field from Memo forms. You could also check the view option, show multiple entries as separate values so show each one on a new line. This will give you the list but will contain multiple duplicate names (if you've emailed the same person more than once using that database), so you could categorise the column.

Once in a view, just export the view.
0
 

Author Comment

by:Marv1n
ID: 37789644
Would you be so kind as to assist/direct on how to configure the view?

Thanks!!!
0
 
LVL 7

Accepted Solution

by:
Sam654 earned 2000 total points
ID: 37789715
Details on how to create a new view.
http://extranet2.ahrq.gov/help/help7_client.nsf/b3266a3c17f9bb7085256b870069c0a9/7a7ce023202829c68525704a004d7fd5?OpenDocument
Just go with the default and don't base it's design on anything so just create it from blank.

Then click change the view selection formula to (including the quotes)

"Memo"

This will ensure that only forms of type Memo appear, they are emails.
Then create a column and inthe column formula type

"SendTo"

Double click on the column header to play around with the column settings, this is where you make it a categorised view and show separate entries for multiple values.

Give it a go and get as far as you can and give a shout back if you're stuck.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 11

Expert Comment

by:larsberntrop
ID: 37790609
Without mail journaling setup in advance, you cannot guarantee that the list will be complete. For while I personally save most sent mail, this is in no way enforced. And a user may delete documents from the Sent mail view...
0
 
LVL 15

Expert Comment

by:akhafaf
ID: 37803662
Hi there marvin,,

May I ask about the reasons why you want to dump this list ?? Because if you just want to have an idea about the emails sent from this particular database you can search the Log file of the mail server of this database.


Best Wishes
0
 

Author Comment

by:Marv1n
ID: 37805401
Hi Akhafaf,

The reason I need this is this mail db serves as the originator of our shipment status updates for customers, and I'd like to send anyone who got an email from this process a questionnaire.


Thanks!
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month7 days, 2 hours left to enroll

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question