I am confused with the following issue:
The data I get looks like this:
emailadress       value1    value2 
test@test.com     Hello     Hello 
test@test.com     Hello     Hello 
test@test.com     Hello     Hello
newuser@new.com   Hy        Hello
I have tried the following so far:
I made a List and a Dictionary, but so far unfortunately not working. Email gets sent to all user(Simulation) with same content.
So User: test@test.com gets following: Hello+Hello Hello+Hello Hello+Hello + 
Hy+Hello  <- wrong
and same for user newuser@new.com
Update: Here is Code:
ErrorData Class
public class ErrorListData
    {
        public string mailadress;
        public string queryName;
        public string queryDesc;
        public string todo;
        public string key;
        public string link;
    }
The Data i get:
string errordataKey = rs.Fields[2].Value.ToString();
                        string errordatalink = fileName;
                        string errordatamailadress = rs.Fields[3].Value.ToString();
                        string errordataqueryDesc = rs.Fields[6].Value.ToString();
                        string errordataqueryName = rs.Fields[5].Value.ToString();
                        string errordatatodo = rs.Fields[7].Value.ToString();
How i add:
this.errorData.Add(new ErrorListData
                        { key= errordataKey, link= errordatalink, mailadress= errordatamailadress,
                        queryDesc=errordataqueryDesc, queryName= errordataqueryName
                        , todo= errordatatodo
                        });
And how i go throw them:
var distinctItems = errorData.GroupBy(c => new { c.mailadress })
                     .Select(c => c.First()).ToList();
        foreach (var item in distinctItems)
        {
            Logger.Debug("In Distinc Items:"+item.mailadress);
            Logger.Debug("In Distinc Items:" + item.queryDesc);
            Logger.Debug("In Distinc Items:" + item.queryName);
            Logger.Debug("In Distinc Items:" + item.todo);
        }
 
    