[qbsuser]

I am pretty new at writing codes but maybe someone here knows the solution. I have put a list of email addresses in a table and some additional information.

The headers are "email", "institution", "Id (key,dealer number)", "filename". Institution may have many email addresses, but the addresses only occurs once. Each institution has an id (dealer number). For every email there should be a attachments that matches the institution (all filenames start with "provision monthly - "dealer number".pdf").

The table looks like this:

email institutiton id filename
*1@*.com dealer1 20502 20502
*2@*.com dealer2 20503 20503
*3@.com dealer 3 20504 20504

Is it possible to write a code that creates a email for each address that contains the file? I know I'm probably asking a lot but I can't seem to make this work out my self.
I know how to create predefined body and subject etc, but the logic of the rest of the code eludes me... All file paths are d:/provision monthly - "filename".pdf.

Hoping that someone can point me in the right direction