Search results

:)

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>>."

Thanks for that, I'll have a play around and see if I can get to working

I'm presuming thats something like .fieldname How would I load it via the code given

Basically yes, I want to load the textfile which has the body of the email message and also populate various parts of the message to make it personal to the reader

Hi all. I have CDO working well to send a test message to the recipients of a table (This will change later to an on demand query) What I'd like to do is use a textfile template for the message which will be populated from the recordset. What do I need to do with the code to make this work...

Hi Bob. That does indeed seem to work exactly as required. I guess it has something to do with the DateValue string. Thanks