I hate doing this because I have searched and searched BUT... I have a query I want to email to everyone's email address in a field in that query. Another issue is...in that field there are multiple repeats of the same email address. I don't want to send that same query to the same email multiple times. If anyone can help me with this I would be GREATLY APPRECIATIVE!!! Thanks
Another email issue
- Thread starter Dactyl
- Start date
- Local time
- Today, 02:46
- Joined
- Jul 9, 2003
- Messages
- 17,642
Helen Feddema's Website
I would suggest you start by looking at Helen Feddema's Website where she has some good examples, and I believe one or two show you how to send emails from MS Access.
I would suggest you start by looking at Helen Feddema's Website where she has some good examples, and I believe one or two show you how to send emails from MS Access.
- Local time
- Today, 02:46
- Joined
- Jul 9, 2003
- Messages
- 17,642
- Local time
- Today, 02:46
- Joined
- Jul 9, 2003
- Messages
- 17,642
Well didn't spend much time looking at them did you! I just had a quick look through those links and I found this one: http://support.microsoft.com/?id=318881
Maybe I am not reading it right but I can send to multiple recipients. The problem is the email addresses repeat themselves because the criteria I have to use. I have to send the email based off of a query where one of the fields is the email address I have to send the report to.
For instance based on >="20070926" pulls x number of records. Thoses records have a field of say "ABX0JFTR" where the email field is based off of the first two characters "AB". So if a record pulls "ABX0JFTR" and the next is "ABUHDSR1" the email is going to be the same...does that make sense? I am not sure how to group the emails together so all "AB" just pulls one email address.
For instance based on >="20070926" pulls x number of records. Thoses records have a field of say "ABX0JFTR" where the email field is based off of the first two characters "AB". So if a record pulls "ABX0JFTR" and the next is "ABUHDSR1" the email is going to be the same...does that make sense? I am not sure how to group the emails together so all "AB" just pulls one email address.
- Local time
- Today, 02:46
- Joined
- Jul 9, 2003
- Messages
- 17,642
I think there's a misunderstanding, I took your message to indicate that you needed some way of sending an e-mail, I am now thinking you are able to send an e-mail? Yes? If that's the case then the links I have sent you will be of no use.
it sounds like you need another query to remove the duplicates from the results you have and that you need to use the results of that query to base your emails on
access will build you a duplicate query using the find duplicates wizard and you should end up with a query which gives you all the values of the field you are interested in and the number of duplicates
if you look at this query in design view and change the criteria from specifying a count >1 to >0 then you will get a query which returns all the unique email addresses in your list and the number of times each one is repeated (it sounds like you don't actually need the counts so you can just uncheck 'show' on them)
access will build you a duplicate query using the find duplicates wizard and you should end up with a query which gives you all the values of the field you are interested in and the number of duplicates
if you look at this query in design view and change the criteria from specifying a count >1 to >0 then you will get a query which returns all the unique email addresses in your list and the number of times each one is repeated (it sounds like you don't actually need the counts so you can just uncheck 'show' on them)
Similar threads
Solved
Email Report