VBA Code for sending emails via Outlook

[CP611]

I'm trying to write a code with no experience of writing code following a You Tube video to send emails via Access and Outlook. I have the below code but keep getting the error code Expected: line number or label or statment or end of statment when I write in the second line. I basically want it to look like this



To User123
You have entered the below form on 03/11/2023
(details of entry)

Msg = "To " & AddedBy & ",<P>"
"You have entered the below form on " & TransactionDate & ",<P>"

Thank you!

[Welshgasman]

And just where exactly are you writing this?

As it stands, it is complete nonsense.

Please supply the link that got you started on this.

Perhaps look at the examples here.
https://learn.microsoft.com/en-us/of...cmd.sendobject

[CP611]

Hi there thank you for replying, I was using this video (https://www.youtube.com/watch?v=s-Z0LHgipVE) but I managed to get it to work in the end!