Commander Dave
Registered User.
- Local time
- Today, 03:43
- Joined
- Dec 13, 2010
- Messages
- 11
I have used Access in the past as a contact manager and remember being able to create a Query and email based on the contents of the Query.
I'd simply like to select all people in a particular category (field created) and then email one email (bulk) to all of them. For some reason I can't figure out how to do this in Access, and haven't found the solution on here.
Example:
First Name | Last Name | Email | Category
Jim Kelly jimbob@... Student Pilot
Orville Wright orville@.... Pilot
Wilbur Wright wilbur@.... Pilot
Grace Slick grace@..... Singer
I want to email all of the pilots in the above list. I have created a Query with a wildcard "*pilot*" which should give me any reference to pilot.
However once I have the Query displayed I can not seem to easily email the group.
I am using one of the Contacts templates provided in Access 2010.
I'd simply like to select all people in a particular category (field created) and then email one email (bulk) to all of them. For some reason I can't figure out how to do this in Access, and haven't found the solution on here.
Example:
First Name | Last Name | Email | Category
Jim Kelly jimbob@... Student Pilot
Orville Wright orville@.... Pilot
Wilbur Wright wilbur@.... Pilot
Grace Slick grace@..... Singer
I want to email all of the pilots in the above list. I have created a Query with a wildcard "*pilot*" which should give me any reference to pilot.
However once I have the Query displayed I can not seem to easily email the group.
I am using one of the Contacts templates provided in Access 2010.