How can I email a spreadsheet as plain text using MailEnvelope oranother method...

[alan82]

Hi all,

I am looking for some help with automating the operation of emailing a
spreadsheet using the MailEnvelope property.

I am able to automate this already. But, my problem is that the email
must be sent as plain text because it is to be sent to a Blackberry!

So, if is was performing this task in Outlook I would select from the
menu:

Actions -> New Message using -> Plain Text

Can I replicate this in Excel using MailEnvelope? Or, is there another
methods to reach the same end?

Thanks in advance for your help.

A

 

[brzak]

Hi all,

I am looking for some help with automating the operation of emailing a
spreadsheet using the MailEnvelope property.

I am able to automate this already. But, my problem is that the email
must be sent as plain text because it is to be sent to a Blackberry!

So, if is was performing this task in Outlook I would select from the
menu:

Actions -> New Message using -> Plain Text

Can I replicate this in Excel using MailEnvelope? Or, is there another
methods to reach the same end?

Thanks in advance for your help.

A

hi Alan

I'm not aware of an equivalent in Excel. As you can appreicate, unlike
outlook, structure is a lot more important ins a spreadsheet.

Even if the spreadsheets in question are relatively simple, and only
the cell value needs to be exported, then there would be a few
options, but would involve some work.

With native excel 2007 files (xlsx, xlsm - though not limited to i
don't think) you are able to 'unzip' it, teh resulting files are text
that define the structure / contents of teh spreadsheet (as you get
more complicated files).

To see what I mean, change the extension of a 2007 file from .xlsx
to .zip, then extact and explore the contents.

That may be more information tah is required, and it is defined using
microsoft's OOXML.

Hope that is useful in some way