I would like to send a single message to all of my E-Mail address.
Db = database1
Table = E-mail
Field = E-Mail Address's
My VBasic skills are nil
Any help would be appreciated
Thanks
I would like to send a single message to all of my E-Mail address.
Db = database1
Table = E-mail
Field = E-Mail Address's
My VBasic skills are nil
Any help would be appreciated
Thanks
You will have to use VBA. Common topic. Search forum and Google. Here is a start:
https://www.accessforums.net/import-...ook-18221.html
https://www.accessforums.net/access/...ect-17713.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks June7 will give it a try.
Still trying June7, I can't find anything I can work with.
The example at Blue Claw was the closest I could find. It shows cycling through a recordset to send individual emal to each address. It uses a clone recordset of an open form. Could instead open a recordset from a table.
You will have to learn VBA to build and maintain this process.
The other links show use of other properties of the mail object. There is no one-stop source for email code. Have to pull together from multiple references.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
OK June Thanks