Re: Excel File to Email

> Don't assume that these excel sheets are very transportable. I'm pretty
darn
> sure that the Excel query (it is not an AS400 query stored in excel btw,
> duh)
> is stored on the users disk and is not a part of the sheet itself, and
the
> autoupdate function uses ODBC, and a specific driver name, so that if you
> did send it to another user, they would have to have the same ODBC driver
> name in order to update the spreadsheet, and that's assuming no query.

The assumption of the original request in the thread was that the
spreadsheet would update the data AND THEN email itself.  So, since the
data has already been refreshed, an ODBC driver would not be necessary on
the receiving end - but could be created if the receiver then wanted the
ability to refresh when needed.

> Now then, if you were to update it locally (using auto-open?) and have
full
> Adobe Acrobat and were to use Adobe's "convert to PDF and email"
> function..............that might have possibilities..............

It's not really necessary.  We have a "Current Orders On Credit Hold"
spreadsheet that this code was lifted from.  In this case, the A/R manager
opens the spreadsheet, pushes a button to refresh the data, pushes another
button to email.

NOTE: not included in the original code was a note that it is written to
email another spreadsheet - NOT itself.  This logic is due to not wanting
to email the Controls sheet and include the macro logic; the originating
spreadsheet makes a copy of itself including only the data spreadsheet and
then mails THAT spreadsheet.  But it could be easily be changed to mail
itself.

Bill