Emailing Customers with data from a table

[Elbows]

I have a table with all of the relevant data.
I want to automate an email to each one with the information that is held in the table. Much like a mail merge.


The email would be in one field.T
he subject would be: "Your item[ Item Name] has been shipped."
The body of the email would be: "Thanks for buying [product] on [date of purchase] etc etc."

My only problem is that I'm shit at code so I wanted to know if I could do it with Macros.

I could do it through a combination of using max records: sending an email, then repeating the exercise until all of my records have been sent.

I can try code but get a bit lost with knowing where to edit it.

Any thoughts or pointers.

Elbows

[June7]

Macro can't do this. I have responded to a number of threads on the topic. Search forum on keyword 'email' and username 'June7'. Here is one https://www.accessforums.net/showthr...ails-on-update