Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How can an Excel file be attached to an email using mailto?

Posted on 2006-05-04
Medium Priority
Last Modified: 2008-01-09
Hi Experts,

How can an Excel file be attached to an email using mailto?

Question by:indyng
LVL 12

Expert Comment

ID: 16609658
Set oCDO = Server.CreateObject("CDO.Message")
      With oCDO
            .To = "somebody@somewhere.com"
            .From = "somebodyelse@somewhere.com"
            .Subject = "your subject"
            .HTMLBody = "your email body"
            .AddAttachment "complete path to excel file to be attached"
      End With
Set oCDO = Nothing

Expert Comment

ID: 16610304
the above answer is very good.  If you host your site yourself its ok.  If you host using an online hosting service check to make sure they have the CDO object and asp scripting available.

www.brinkster.com is a good one that has both
LVL 25

Accepted Solution

kevp75 earned 2000 total points
ID: 16610833
if i'm reading the question right,
you are using <a href="mailto:some@email.com">Email Link</a>

in which case it is not possible to add an attachment using this method, other than suggesting to the user they browse for the file and attach it manually.  I Believe the most you can do is add a subject to the link (I say believe, because I would not try to add anything else to the link, befoire I used another method to send an email), and it would look like:<a href="mailto:some@email.com?Subject=Some Subject">Email Link</a>

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question