Pulling ALL records in subform into VBA drafted email

M

MacNut2004

Hello,

I have a form that has a subform which can have multiple records entered.
What I am trying to do is to pull in data from the form AND subform into an
email drafted by VBA within Access. The problem I am having is that VBA Is
only pulling ONE of the records from the subform into the email. Seems that
it's pulling in the record where the cursor was last at in the subform.

Any idea how i can pull ALL records from the subform into the email?

Thank you in advance!!!
MN
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help finding old, outdated contacts in Outlook 365 on my PC 0
VBA code returns no records hwenKey ID is added 14
Change the "From" email address VBA 0
Populate main form from subform record 0
Duplicate records of subform based on main form 3
VBA concatenate ranges into a new document 0
DLookup in Continuous form 0
How to insert HTML into an Outlook 2021 email 0

Top