Automatic Messaging through Access (1 Viewer)

[Jopetes]

I have a members list and want to update each member through messaging (email or whatsApp) their registration umber and other instructions.

Is it possible through access. Kindly help.

 

[arnelgp]

youll be needing a table that will hold the message you want to send.
fields should include:

member id
email address (or linked to main member table)
message
attachments (optional)
date to send
sent status

hidden form that will act as messenger.
the form has a Timer event.
check if there is unsent message from the above table periodically.
send message using Outlook automation.
update the Sent Status of the table.

 

[GinaWhipp]

Hmm, perhaps this will get you started...
https://www.access-diva.com/vba18.html