Embedding Excel in a Send Mail Task
-
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.
-
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
-
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! -
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