Access World Forums

arnelgp
arnelgp
i have a demo database made.
see this link in Sample Database section:
  • Love
Reactions: Ihk
I
Ihk
Very beautiful and nice. But key question is how to put this table into outlook email body.
For that I will need few field of table and 5-7 row, this is done by Filtering Query
then have to bring that in a table form into outlook .HTMLBODY , How?
arnelgp
arnelgp
which table are you going to convert to html table and what is the Filtering criteria?
I
Ihk
Sample db below
1) Update record: sends only one record
2) Arrival today: want to send all records
Yesterday "TheDBGuy" helped me and now Send button on this page can send all records.
I am looking to arrange this in tabulated form in outlook email body

arnelgp
arnelgp
try this out.

Attachments

  • Send Email All records.accdb
    1.2 MB · Views: 38
  • Love
Reactions: Ihk
I
Ihk
Thank you very much. I was pretty sure you are the one who can definitely do this. A of love for you. kind regards
I
Ihk
Sorry to disturb you, I have question. If If filter query between dates based on form
Code:
Between [Forms]![ArrivalTodayForm]![txtStartDate] And [Forms]![ArrivalTodayForm]![txtEndDate]
This works in form in the form of list box, but Email Sending button it gives "error 3061 too few parameters expected 2"
But it works fine if use direct date in query or Date() or like
Code:
Between Date() and Date()-6
I
Ihk
@arnelgp any suggestion for this above problem?
Top Bottom