Inserting multiple rows into an email created by VBA

[chuckcoleman]

Hi, I have been using VBA to send an email for several years now. The email is generated from a form where payments are inserted for property lots. Things have changed and I now need to include in the email information how much the payment was for each lot. For instance, owner ID number 21 owns Lot number 445 just paid $600 in addition to paying $300 on lot number 446. Therefore, instead of something relatively simple, I now need to essentially include two or more rows from a query in the email.

Any suggestions on a way to accomplish this?

Chuck

 

[pbaldy]

I would open a DAO recordset on the query and loop through it, adding to the body within the loop.

 

[chuckcoleman]

I would open a DAO recordset on the query and loop through it, adding to the body within the loop.

Thank you. I’ll try your suggestion tomorrow morning.

 

[pbaldy]

No problem, post back if you get stuck. I have automated apps that do this type of thing.

 

[arnelgp]

you need to use Outlook automation or CDO, if you don't have the code yet.

 

[Gasman]

Here is how I did something similar.
However this takes into account several records for a client, deposits or payments.

Yours could just be the table with the values that I get from each record.

Had to attach as too large to paste.

 

[ebs17]

I now need to essentially include two or more rows from a query in the email.

How do you add the one line so far?
For ease of use, this would be the interesting place to meet your requirements.