Email VBA code

[idmnstr via AccessMonster.com]

Hi,

I have a form that sends an email based on the info on the form via a button
press. I have just changed to a parent and child forms. The button is
current on the child form and works fine. The only problem is that if I have
multiple children for one parent then I have to navigate to each child, press
the button, and then combine the email messages.

I would like to create something that will process the Parent and multilple
Children and create only one email. My query prompts for the Parent key and
obtains all the info needed for forms.

I looked in this forum for an example but was not able to find one. If
someone knows of an example that would be great.

Thanks in advance,
Jim