N
nquirer
Hi
I've created a form button that generates an email message, and populates it
with data from the current form record.
Now I want to display results from a query/report as a list, eg:
Dear Ian
Thank you for your order.
We have shipped the following items, as requested:
[product list]
Where [product list] is a comma separated list of the products returned by
the query or report.
I can get the email to display a single product by using docmd.openreport
and docmd.selectobject, but how do I get the list of products to show?
I'd appreciate any guidance on this.
I've created a form button that generates an email message, and populates it
with data from the current form record.
Now I want to display results from a query/report as a list, eg:
Dear Ian
Thank you for your order.
We have shipped the following items, as requested:
[product list]
Where [product list] is a comma separated list of the products returned by
the query or report.
I can get the email to display a single product by using docmd.openreport
and docmd.selectobject, but how do I get the list of products to show?
I'd appreciate any guidance on this.