Recent content by david_johnson

Thanks - Can you provide the link to one? I see plenty of posts about sending emails and printing reports. The only thread I've been able to find about creating an email and then printing that email is my own, but I can certainly accept I'm just missing them all. Thanks!

Greetings, I'm doing some work for a government agency so there are all sorts of "fun" records retention requirements that might seem atypical. I'm needing to create emails based on a table (which is all done and working perfectly) but it would also be very beneficial to be able to...

I have two tables. One contains a list of applicants, the other the list of contacts for that applicant that will feed the email's table. The join is on the Applicant ID, so in the contacts table 6 rows will have the same applicant ID (always 6). What I can't figure out how to do is to filter...

That code worked perfectly, thanks! I'm having what, I hope, is my last issue before being done. I have two tables. One contains a list of applicants, the other the list of contacts for that applicant that will feed the email's table. The join is on the Applicant ID, so in the contacts table...

So that worked perfectly. My needs have changed somewhat and I need the table in between text. Building on your method Mark, I declared "asPostTable" but I can't figure out how to insert it. The code below inserts the post-table text into the rightmost column heading in the table. What am I...

Yes, I believe that is what I'm looking for. I'll try it out. Thanks!

So I don't know if this is my limited experience with HTML or what but it seems what I need to do is simple, though it won't work. I need to create an email with some variables here and there, and then underneath I need an HTML table that pulls from an Access table. The part I thought...

I did. The textbox now has this as the control source: =DLookUp("mthly_rpt_period_month","monthly_report_period","mthly_rpt_period_due_date = '" & [mnthly_rpt_due_date] & "'"). I have quadruple-checked the variable/table names and had someone else check them too. If I didn't shave my head I'd...

I appreciate the help. This code gives returns "#ERROR" in the textbox. Not sure what I'm doing wrong.

So I canNOT figure out what is wrong with my dlookup language. I used the table references just to make certain its clear. I want to look up a value (mthly_rpt_period_month) in "monthly_report_period" based on the user entry in combo box "mnthly_rpt_due_date" on the form "Switchboard" based on...

--- How would I go about that? It does sound like it would be easier and it would it sounds like it would have the added advantage of staying in Access rather than having to dink around in Word.

Greetings, My ultimate goal is to take many fields for many records I have in a query, export them into a fill-able document and email them to clients. The clients need to enter some text into a few boxes (not the fields I'm providing) and send it back. I don't need to collect that data they...