Do you need a found set of records or just the list of email addresses?
I need a found set of records preferably but I would settle for just the email addresses at this stage.
1 of 1 people found this helpful
A list of email addresses is very easy. A use values from field value list can list all addresses without any duplicates. ExecuteSQL could also be used with the DISTINCT keyword to get the same list.
To to get a found set you might need to use a loop to omit duplicates after sorting to group by ID.
On the other hand, a summary report can be set up that lists each email and associated fields once.
Other options are also possible.
Okay great thank you. A couple of questions.
I made a value list based on the email address and as you say there are no duplicates. Now how would I export that list to a csv file?
I have no experience with ExecuteSQL so how would look as a script? I assume there is something I need to type into the SQL text box with the word DISTINCT.
I know how to set up basic summary reports but not sure how I would go about doing it in this case.
Thanks again and I appreciate your help.
Phil I found a very helpful video on ExecuteSQL so thank you for the clue. I now understand how to extract the emails which answers my question for now. Thanks again.
You also could sort your records by email address and use the Group By option to export each email address once. Had I known that you wanted to export, I would have put that in my first response.
How do you setup to list only one record in the group?
You don't. You sort the records and then select the "group by" option in the export dialog. You then get one row for each group in the exported data.