Send attachment via CDO

[richardrekos]

I need to send an attachment w/ where the filename is the name of the machine (.xml). Is it possible to use a variable like strMachine and use that in the filename? I don't know the correct syntax...


Set objEmail = CreateObject("CDO.Message")
objEmail.From = "richard.rekos@questionmark.com"
objEmail.To = "richard.rekos@questionmark.com"
objEmail.Subject = "AT Output"
objEmail.Textbody = "AT Output"
objEmail.AddAttachment "c:\assettracker\data\strMachine.xml"
objEmail.Send

WScript.quit

 

[PHV]

Replace this:
objEmail.AddAttachment "c:\assettracker\data\strMachine.xml"
By this:
objEmail.AddAttachment "c:\assettracker\data\" & strMachine & ".xml"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[richardrekos]

Thanks very much!