Yep. That's what the Email Templates are. Have you gotten that far yet?

Hi, sorry.  I probably didn't explain clearly.  I would like the information to be put in a table layout (similar to a table layout in word) within the form.

Also, I have a query which shows journal entries for different projects.  One project may have multiple journal entries, but each entry is a separate record.  Is there anyway to put all the journal entries per project into a template e.g.

Project numberProject nameJournal namePublished monthPublished yearLink
1Project1Journal3Month12020
1Project1Journal2Month12020
1Project1Journal1Month12020
2Project 2Journal2Month22020
2Project 2Journal1Month12020

So each letter template will just have all the information about the journals for one project.

For your first question, if you're sending a Report as a PDF attachment, then you can use all of the formatting you want in Access to create a table-like layout. If you're sending an HTML formatted email, then you can use HTML table tags. TABLE, TR, TD, etc.

As far as your second question goes, sure. Just set up a query where your criteria is the ID of the project. The generate a report based on that query using Sorting and Grouping.

I see from your badges that you're just a Beginner user, so this next tip is probably beyond your skill level, but if you're creating one text email (regular or HTML formatted) then it gets a little more difficult. You'd need to use a Recordset to loop through all of the items in that Project and add the text you want from each journal entry to the body of the email. This is a little tougher, but produces a nice result.

Thank you, I'll give it a go