Solved

Email to from Access Database

Posted on 2014-04-10
5
335 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 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