Solved

Email to from Access Database

Posted on 2014-04-10
5
333 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
  • 3
5 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 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 84
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Add records to a form to a table 11 40
Calculation in Access 5 26
Access 2013 DoCmd.TransferSpreadsheet Not Working in Win 10 8 28
Run SQL Server Proc from Access 11 31
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

773 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