{"id":70923,"date":"2004-11-29T13:42:00","date_gmt":"2004-11-29T13:42:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2004\/11\/29\/how-can-i-attach-a-file-to-an-email-sent-using-cdo\/"},"modified":"2004-11-29T13:42:00","modified_gmt":"2004-11-29T13:42:00","slug":"how-can-i-attach-a-file-to-an-email-sent-using-cdo","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-attach-a-file-to-an-email-sent-using-cdo\/","title":{"rendered":"How Can I Attach a File to an Email Sent Using CDO?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! I understand how to use CDO to send an email, but how do I include an attachment with that email?

— RT<\/P>\"Spacer\"\"Hey,\"Script<\/A> \n

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 wasn\u2019t eating, playing tackle football with a phalanx of nephews much bigger and – sigh – much younger than he is. It\u2019s safe to say that this Scripting Guy was hoping to ease his way back to work, and this question is a good way to start.<\/P>\n

For those of you who aren\u2019t familiar with CDO (short for Collaboration Data Objects) this technology provides a way for you to send email from a script. As long as you have an SMTP server located somewhere on your network, you can create and send an email using code similar to this:<\/P>

Set objEmail = CreateObject(“CDO.Message”)<\/p>\n
objEmail.From = “helpdesk@fabrikam.com”\nobjEmail.To = “administrator@fabrikam.com”\nobjEmail.Subject = “Server down” \nobjEmail.Textbody = “Server1 is no longer accessible over the network.”<\/p>\n
objEmail.Configuration.Fields.Item _\n    (“http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendusing”) = 2\nobjEmail.Configuration.Fields.Item _\n    (“http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpserver”) = _\n        “smtpmailer” \nobjEmail.Configuration.Fields.Item _\n    (“http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpserverport”) = 25\nobjEmail.Configuration.Fields.Update<\/p>\n
objEmail.Send\n<\/PRE>\n
We\u2019re not going to explain this script in any detail today; for a quick overview of the individual properties used here, see the Microsoft Windows 2000 Scripting Guide<\/B><\/A>. You can probably figure out the From<\/B>, To<\/B>, Subject<\/B>, and Textbody<\/B> properties without too much trouble. The URIs (e.g., http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendusing) are boilerplate code that can typically be left as-is; in most cases, the only one you\u2019ll need to change is smtpserver<\/B>. In our sample code, we\u2019ve referenced an SMTP mail server we named smtpmailer<\/B>; you\u2019ll need to replace that with the name of your<\/I> SMTP mail server.<\/P>\n
By the way, these URIs concern a lot of people: they wonder why they need to connect to Microsoft in order to send an email. The truth is, you don\u2019t actually connect to Microsoft; these URIs are just properties. Why are they referenced like this? To be honest, we don\u2019t know. But don\u2019t worry: your mail doesn\u2019t get routed through Microsoft, and no one here reads it. Trust us, we have enough problems keeping up with our own email, let alone taking time to read someone else\u2019s.<\/P>\n
Now, what about adding an attachment to this email? All it takes is one additional line of code, much like this line which attaches the files C:\\Scripts\\Output.txt to the email:<\/P>
objEmail.AddAttachment “C:\\Scripts\\Output.txt”\n<\/PRE>\n
That\u2019s it; add this line of code to the script, and you\u2019ll have yourself an attachment. The entire script will look something like this:<\/P>
Set objEmail = CreateObject(“CDO.Message”)<\/p>\n
objEmail.From = “helpdesk@fabrikam.com”\nobjEmail.To = “administrator@fabrikam.com”\nobjEmail.Subject = “Server down” \nobjEmail.Textbody = “Server1 is no longer accessible over the network.”\nobjEmail.AddAttachment “C:\\Scripts\\Output.txt”<\/p>\n
objEmail.Configuration.Fields.Item _\n    (“http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendusing”) = 2\nobjEmail.Configuration.Fields.Item _\n    (“http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpserver”) = _\n        “smtpmailer” \nobjEmail.Configuration.Fields.Item _\n    (“http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpserverport”) = 25\nobjEmail.Configuration.Fields.Update<\/p>\n
objEmail.Send\n<\/PRE>\n
As long as we have your attention, we\u2019ve had a couple people ask us how they can send email if their SMTP server requires authentication. To tell you the truth, that\u2019s a tough question for us to answer because (for various reasons) we don\u2019t have a way to test that scenario. However, adding a user name and password to your script is a good place to start:
<\/P>
objEmail.Configuration.Fields.Item _\n    (“http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendusername”) = “fabrikam\\kenmyer”\nobjEmail.Configuration.Fields.Item _ \n    (“http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendpassword”) = “&gr54#wgha”\n<\/PRE>\n
The preceding code logs you on to the SMTP server as fabrikam\\kenmyer<\/B>, with the password &gr54#wgha<\/B>. Note that this does<\/I> send the user name and password in cleartext. Consequently, you probably don\u2019t want to send email using an Administrator account. Instead, create a user account that has the right to send email (but little, if anything else) and log on using that account. For more information, check out the official CDO documentation<\/B><\/A> on MSDN.<\/P>
\n
\n\n\n\n
\"Top<\/A>Top of page<\/A><\/TD><\/TR><\/TBODY><\/TABLE><\/DIV><\/p>\n","protected":false},"excerpt":{"rendered":"
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 wasn\u2019t eating, […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[28,3,182,5],"class_list":["post-70923","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-messaging-and-communication","tag-scripting-guy","tag-sending-email","tag-vbscript"],"acf":[],"blog_post_summary":"
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 wasn\u2019t eating, […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/70923","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=70923"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/70923\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=70923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=70923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=70923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}