Export a list of mail recipients from Lotus Notes

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!!
Who is Participating?
Sam654Connect With a Mentor Commented:
Details on how to create a new view.
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)


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


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.
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.
Marv1nAuthor Commented:
Would you be so kind as to assist/direct on how to configure the view?

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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...
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
Marv1nAuthor Commented:
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.