Recent content by mousemat

:)

Excellent. It's been a long Christmas period. All working as required.

Hi DBGuy How would I reference the textbox from the form?

Hi I have been using the CDO method to send emails to people using text templates and placeholders, which work really well. What I'd like to do is determine at the time of sending the emails, which template to use. Currently the text template is written within the module itself. Const...

.AddAttachment rs.Fields("FormLocation") Worked perfectly. hanks fr all the help

So I have, now getting error 13 Type Mismatch But when I have .Attachment.Add filename I get the error 438

I get this error now with the code in answer 6 Again though hovering over the line shows the path and the file etc

I get the same error as highlighted at the start of the thread

No joy with the Cheekybuddha

This is the path as found detailed by rs.fields("FormLocation") C:\AccessTextFiles\ChristmasFayre2020BookingForm.pdf

.AddAttachment = filename gives the same error

I have code which work when the attachment is sets C:\AccessFiles\some.pdf However. I want to send a file that has been referenced in a text field within the table. The code gives a runtime error 438 but hovering over the line it stops at, shows the location and the file that I want to send out...

Excellent. That's great. Many thanks for your help.

Hmm getting there slowly. Ive added the Placeholders in the code, on separate lines and added the place holders to the text file but only getting the first placeholder populated. If Not (rs.EOF And rs.BOF) Then Do Until rs.EOF = True 'On Error Resume Next With imsg...

Got it to send the text file. now just trying to sort the laceholders. "<<customer name>>." just gives me "<<customer name>>."