Separate emails to multiple recipients with only items due on them (1 Viewer)

jack555

Member
Local time
Today, 21:34
Joined
Apr 20, 2020
Messages
93
Having a task list due on every user. Would like to send a reminder email to the respective users about their pending item and summary with a click of a button instead of sending one by one. Is this possible to achieve? kindly assist.
 

Gasman

Enthusiastic Amateur
Local time
Today, 17:34
Joined
Sep 21, 2011
Messages
14,044
Bit like asking 'How long should my piece of string be? ' :(

Need a little more info :unsure:
 

theDBguy

I’m here to help
Staff member
Local time
Today, 10:34
Joined
Oct 29, 2018
Messages
21,358
Check out the similar threads below.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 17:34
Joined
Jul 9, 2003
Messages
16,244
Find items due with a query. Get the SQL of the query, (details in my blog below)

Use the results of the function (a string delimited for outlook) in the solution provided by Gina Whipp, link to Gina also available in my blog:-

 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 17:34
Joined
Jul 9, 2003
Messages
16,244
Oops!

Link to Gina is in this Blog:-


Plus more stuff you may find helpful...
 

jack555

Member
Local time
Today, 21:34
Joined
Apr 20, 2020
Messages
93
Oops!

Link to Gina is in this Blog:-


Plus more stuff you may find helpful...
Thank you. I will try it.
 

jack555

Member
Local time
Today, 21:34
Joined
Apr 20, 2020
Messages
93
Oops!

Link to Gina is in this Blog:-


Plus more stuff you may find helpful...
Looked at this; seems more advanced level for me.

My concern is a simple task. There are certain items due on each user every month. These due items are already filtered and available as a query. Now, how to send reminder emails to each user with the items only due for them?

IDTaskUserDue Date
1collect moneyjack
15-06-2020​
2pay the billjack
01-08-2020​
3book ticketsmark
01-07-2020​
4pick up some itemslucy
01-07-2020​
5service the carsteve
01-08-2020​
6renew the leaselucy
01-08-2020​

From the above table, jack receives emails with the info about items pending due for him and like others only receives the info against them. Either it may be in excel, pdf, text or whatever format.
 

Gasman

Enthusiastic Amateur
Local time
Today, 17:34
Joined
Sep 21, 2011
Messages
14,044
Well the easiest way would be to send an email for each record?
The tidiest way IMO would be to send one email for ALL the items for a particular destination?

For that you need to sort in the correct order and then only send when the destination address/user changes.?
Here is something I used in one of my DBs.

Probably more than you need as I used html emails, but it should get you started.?
OK, could not paste, complains about more than 10K characters.
Attach method seems to have changed as well (not for the better BTW :( )

Also look at https://www.youtube.com/results?search_query=send+emails+with+attachments+from+access+database
 

Attachments

  • Send Email.txt
    12.6 KB · Views: 232
Last edited:

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 17:34
Joined
Jul 9, 2003
Messages
16,244
seems more advanced level for me.

Like most things in life the whole process appears difficult, especially if you look at the whole thing.

However once you realise that most things are a series of steps, then it becomes much simpler process.

Your first step should be to create a query that just returns jack's results.

Next turn that query into a PDF.

Now upgrade the query so that you can choose the person from a combobox
instead of having "Jack" as hard-coded criteria in the query.
 

jack555

Member
Local time
Today, 21:34
Joined
Apr 20, 2020
Messages
93
Thank you for the inputs. I will try these steps and resources and come back if anything is required. My VBA skills make this overwhelming. I will attempt to solve it.
 

jack555

Member
Local time
Today, 21:34
Joined
Apr 20, 2020
Messages
93
Well the easiest way would be to send an email for each record?
The tidiest way IMO would be to send one email for ALL the items for a particular destination?

For that you need to sort in the correct order and then only send when the destination address/user changes.?
Here is something I used in one of my DBs.

Probably more than you need as I used html emails, but it should get you started.?
OK, could not paste, complains about more than 10K characters.
Attach method seems to have changed as well (not for the better BTW :( )

Also look at https://www.youtube.com/results?search_query=send+emails+with+attachments+from+access+database
Could you please advise at least how to send an email for each record? sorry I am too naive in executing the wonderful ideas proposed.
 

Gasman

Enthusiastic Amateur
Local time
Today, 17:34
Joined
Sep 21, 2011
Messages
14,044
Could you please advise at least how to send an email for each record? sorry I am too naive in executing the wonderful ideas proposed.
Look at the code I supplied. That is pretty much doing that, just with the added complication of checking if it is the same client.
You do not need that so

Open Outlook App
Get your required records with a recordset
Until EOF of that recordset,
create and populate and email with your data and send
Get next record
Close Outlook App

Also many, many examples with just a quick Google?
 

Users who are viewing this thread

Top Bottom