Thanks June!!! I have created a testing database using the links you have sent to me. I have two tables created (they are linked to an excel file). I have created a Query using the "Join" that you mentioned, and I have created a Query that creates a table. I have managed to make two forms based on the queries that I have mentioned.
I have created a module in Visual Basic. The code that I have used is one that I copy-pasted from a link you gave me. It does not run because it returns me error on the "Set oOutlook" part. I guess I understand a little bit more now about this code. I was looking at it and I guess I should change the following:
instead of "To" in this part of the code it should day "BCC." right? And as per my understanding the "Left -1" it means that it should move one box starting from the left (this was surely the location of the e-mail list of the table that was used to built this code)
Code:
.To = Left$(strEMail, Len(strEMail) - 1) 'Remove Trailing ;
Could you please tell me if I am going right? Thanks!
The excel files can be found in here: http://www.mediafire.com/download.php?v6ebfeu3nf434f3.