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

Posted on 2006-05-04
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

    Set oCDO = Server.CreateObject("CDO.Message")
          With oCDO
                .To = ""
                .From = ""
                .Subject = "your subject"
                .HTMLBody = "your email body"
                .AddAttachment "complete path to excel file to be attached"
          End With
    Set oCDO = Nothing
    LVL 2

    Expert Comment

    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. is a good one that has both
    LVL 25

    Accepted Solution

    if i'm reading the question right,
    you are using <a href="">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=" Subject">Email Link</a>

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    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…
    Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now