Skip to main content
Participating Frequently
July 17, 2009
Question

how to set up a cfmail and output in excel

  • July 17, 2009
  • 1 reply
  • 5873 views

Hi All,

Does anyone know how to set up a cf mailto so that the format is in either TXT or Excel, .xls format.  We are trying to set emails so that they are formatted to import into Excel.  Any help would be appreciated.  Best, Joy

    This topic has been closed for replies.

    1 reply

    Inspiring
    July 17, 2009

    html tables copy and paste nicely into excel.

    or you can create either a delimited text file or excel on your server and attach it to the email

    tignmufAuthor
    Participating Frequently
    July 18, 2009

    Hi Dan,

    I'm really a newbe.  When I adjusted my cf mailto to send as a text file I got this as an email.

    <label>Would you like to request an In-Home Consultation?    </label>,
    <label>Would you like to request a Catalogue?    </label>,
    <label>Name    </label>Joy Lobdell,
    <label>Company    </label>,
    <label>Address    </label>33 Puritan Drive,
    <label>Address 2    </label>,
    <label>City    </label>Port Chester,
    <label>State    </label>New York,
    <label>Zip Code    </label>10573,
    <label>Phone    </label>914-939-4681,
    <label>Email    </label>jrlobdell@optonline.net

    When I thought I sent it comma delimated I got this.


    Would you like to request an In-Home Consultation?    , , Joy Lobdell, , 33 Puritan Drive, , Port Chester, New York, 10573, 914-939-4681, jrlobdell@optonline.net

    and the tech guys said it was not good.  This is a very simple form. and this is what I have for the server and type.

    server="127.0.0.1" type="txt">

    I guess I don't know what I'm doing.

    Best,

    Joy

    Inspiring
    July 18, 2009

    A couple of questions:

    1. What do you mean by "formatted to import into Excel"?  Do you need to create an Excel (.xls) file in your ColdFusion application then attach it to an email?

    2. Can you describe and provide a sample of the desired output?

    3. Can you post your code?