?
Solved

Email to from Access Database

Posted on 2014-04-10
5
Medium Priority
?
349 Views
Last Modified: 2014-04-10
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
Comment
Question by:urjudo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 39992173
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
 

Author Comment

by:urjudo
ID: 39992185
Yes, Rey Obrero, this what I want, you always a rock!!!!  I always appreciate your solution.
0
 
LVL 85
ID: 39992204
You really should ask this as two questions.
0
 

Author Comment

by:urjudo
ID: 39992208
should I close this one and open as another new ticket?
0
 

Author Closing Comment

by:urjudo
ID: 39992245
Thank you!!!
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question