• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

Email to from Access Database

Hi Experts,
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  "111@hotmail.com" instead Doe, Jane 111@hotmail.com  (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

Thanks,
AFSCME.mdb
0
urjudo
Asked:
urjudo
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
SELECT tblContact.UnEmail, [UnLastName] & " , " & [UnFirstName] & "  " & Chr(34) & [UnEmail] & Chr(34) AS Name, tblContact.UnLastName
FROM tblContact
WHERE (((tblContact.UnEmail) Is Not Null))
ORDER BY tblContact.UnLastName;


result

Doe , Jane  "111@hotmail.com"
Smith , John  "abc@yahoo.com"


is this what you want?
0
 
urjudoAuthor Commented:
Yes, Rey Obrero, this what I want, you always a rock!!!!  I always appreciate your solution.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You really should ask this as two questions.
0
 
urjudoAuthor Commented:
should I close this one and open as another new ticket?
0
 
urjudoAuthor Commented:
Thank you!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now