Include form text in generated email

[olivetwist]

I have an embedded macro that sends an email to a shared box once certain information is updated. I am trying to include certain form data in the body of the email msg. can anyone tell me how to reference this as an embedded macro or do I need to convert it to a standard VBA macro?

[jonh]

To refer to a control on a form it's something like

Forms.myform!mycontrol

[olivetwist]

I ended up creating a report with criteria set to match what is in the current form.

[HiTechCoach]

Glad to hear you found a solution.

Thanks for sharing your solution so other may benefit.

[donaldsims]

Thanks!

[BrynjulfRasm]

Thanks for the useful information