Mailto Attachments From Server

[vanillapod]

Hi I have a database that holds report numbers. Each report has a set of files held on the server in a directory named as the report number e.g. WE123. I have a mailto: link which opens outlook inserts a load of addresses in the TO: field, enteres subject and body text but I'd like to have the files from the report numbers folder on the server to also be included as attatchments.

Any help would be cool!

cheers

 

[FesterSXS]

Try using the server to send the email

Set objNewMail = CreateObject("CDONTS.NewMail")
objNewMail.subject = ""
objNewMail.body = ""
objNewMail.from = ""
objNewMail.to = ""
objNewMail.cc = ""

strSearchFile = "c:\search\searchresults.txt"

objNewMail.AttachFile strSearchFile, "Search Information"

objNewMail.Send

Tony

http://www.phoenix-paints.co.uk/portfolio

 

[vanillapod]

cheers FesterSXS I'll give it a go asap, our email server has just gone down so I can't right now! Typical!

Chers