Post reply

Embedding Excel in a Send Mail Task

  • September 26, 2007 at 1:26 am

    #374817

    I am trying to embed a spreadsheet in an email sent using the Send Mail Task in SSIS. The spreadsheet gets embeded as the message source but displays all the formatting characters. Is there a way to configure Send Mail Task to display the spreadsheet and not the formatting characters? Thanks.

  • September 26, 2007 at 5:07 am

    #736303

    How are you embedding the spreadsheet? What format is your email, plain-text or HTML?

    You might be better served attaching the spreadsheet to the email, or getting your results in HTML format.

    --------------------
    Colt 45 - the original point and click interface

  • September 26, 2007 at 5:39 am

    #736313

    watching this topic, to see if it's possible.

    personally I always make CSV or HTML files and change their extension to .XLS, so I never automate Excel, and I've always just attached items, never embedded.

    performance wise, excel is slow compared to raw text manipulation.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 26, 2007 at 5:41 am

    #736316

    Same here... in most cases we embed or attach HTML file, in some special cases we attach Excel file. But I have never tried to embed Excel into a mail.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply