E-Mail & Excel

  • Thread starter Thread starter Mike Caputo
  • Start date Start date
M

Mike Caputo

I'm setting up an auto e-mailer in VB.NET to send daily reports to clients.
I have the main part of that all set, but there are a couple of things I'm
not quite sure on:

1) I'll be sending about 10-20 reports, and am not quite sure how to queue
them. The reports are anywhere from 500K to 3MB, so I imagine this is
fairly important. Does the SMTPMail object handle this automatically, or do
I need to implement something to wait for each message to be sent?

2) I'd like to be able to put Excel-type formatting into the body of the
e-mail without actually going through Outlook Express... I'm pretty sure I
can figure out how to create the Excel sheets I need to create through the
Excel object model, but I'm not sure how to transfer that over to the body
of the e-mail without using Excel's integration with OE.

Any suggestions would be greatly appreciated.

Mike
 
1. I believe that SMTP mail automatically supports the email message
queues.
2. use attachment property to send it as an attachment but i dont think
there is any way to paste the excel sheet in the message body in the SMTP
without going to outlook.
 
Thanks on question 1.

As for 2, I kinda thought that was the case, so thanks for letting me know.
Is there any way to do any type of formatting in the body? This
unfortunately can't be done as an attachment, which I think is silly too...
as usual, this need is based on the old ID10T rule. Thanks for your help.

Mike



1. I believe that SMTP mail automatically supports the email message
queues.
2. use attachment property to send it as an attachment but i dont think
there is any way to paste the excel sheet in the message body in the SMTP
without going to outlook.
 
You can use RTF (Rich Text Format) in the body of the message, as long as
the client email program supports it. (Most modern ones do, I think.)

An RTF string contains special formatting codes to allow you to use
different fonts, sizes, bolding, etc. I think RTF also supports tables, so
you could display tabular information in a way similar to Excel.

Alternatively, you could send HTML (including tables.) Most email programs
support HTML, but some clients might disable HTML emails to block HTML spam
messages.
 
Back
Top