CDO Mail sending attachment via location field

[mousemat]

So I have, now getting error 13 Type Mismatch

But when I have .Attachment.Add filename I get the error 438

 

[Gasman]

I cannot open this, but see how Colin does it.?

EMail Tester - Mendip Data Systems

Database applications for businesses, schools and individuals

www.mendipdatasystems.co.uk

 

[cheekybuddha]

It's .AddAttachment rs.Fields("FormLocation")

 

[Gasman]

It's .AddAttachment rs.Fields("FormLocation")

The o/p assigned that field to filename after opening the recordset.
However cheekybuddha is correct with the method name

How Can I Attach a File to an Email Sent Using CDO? - Scripting Blog [archived]

Hey, Scripting Guy! I understand how to use CDO to send an email, but how do I include an attachment with that email?— RT Hey, RT. And, incidentally, thanks for this question. At least one of the Scripting Guys spent most of his Thanksgiving weekend eating and, on the rare occasions when he...

devblogs.microsoft.com

 

[cheekybuddha]

Yes, but outside the loop.

So if there is more than one record, it will continue to attach the attachment from the first record

 

[cheekybuddha]

The issue is the method.

In the failed attempt in Post#21 the OP was using a nonsense method.

 

[Gasman]

Yes, but outside the loop.

So if there is more than one record, it will continue to attach the attachment from the first record

The o/p actually had .AddAttachment in the original code?

 

[cheekybuddha]

Yes, then obviously confused by the red herring in Post#6

 

[mousemat]

.AddAttachment rs.Fields("FormLocation")

Worked perfectly. hanks fr all the help

 

[cheekybuddha]

Phew! I'm glad we all got there in the end!

I'm sure @Gasman and @onur_can join me in saying "You're welcome!"