How to e-mail from access to outlook

[hogue@montana.com]

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

[June7]

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

[hogue@montana.com]

Thanks June7 will give it a try.

[hogue@montana.com]

Still trying June7, I can't find anything I can work with.

[June7]

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.

[hogue@montana.com]

OK June Thanks