First of all, I want to say "Thank you" to all the experts helped me yesterdaywith my Database. Today, I have a two more questions about the DB that I was asking yesterday.
1). How do I do in the query that shows Doe, Jane "email@example.com" instead Doe, Jane firstname.lastname@example.org (it's in the query name "qryEmailList)
2). This question might be a little difficult and I have totally no idea how to do, please show me step by step if possible (I never done this before)
How do I do if I want to send a email to all the people that I have in my database at the same time from a gmail account. for example, right now I only have two people in the DB, but I will be adding more in the future, I want to go to my gmail account and send an email to everyone and I don't want to send one by one, is anyway to do that? That I can do from my gmail and select all the email address from my database? I attach my DB too