I've had the same problem before and changing to fixed-width font alone didn't
fix it - I had to use the expand command to replace tabs with spaces AND use a
fixed-width font.
Here is an example when I send the email with fixed-width, but no expand
command:
DATABASE SID USERNAME OSUSER TYPE OBJECT_NAME
LMODE SECONDS BLOCK
--------- ---------- ------------ ------------ ---- -------------------------
---------- ---------- ----------
D517 36 LREIMERS Lreimers TX
6 916 0
D517 36 LREIMERS Lreimers TM CT_ADDR_CODE
2 916 0
And, here is an example sent with *with* the expand command:
DATABASE SID USERNAME OSUSER TYPE OBJECT_NAME
LMODE SECONDS BLOCK
--------- ---------- ------------ ------------ ---- -------------------------
---------- ---------- ----------
D500 36 LLEMPERT llempert TX
6 12 0
D500 36 LLEMPERT llempert TM FRL_PERIOD_BAL
3 12 0
Regards,
Brandon
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of bill thater
Sent: Friday, July 29, 2005 4:45 AM
To: sharmakdeep_oracle@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: how to send a fixed-format mail from unix
On 7/28/05, Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx> wrote:
> I am trying to send the output of a sqlplus script
> from Unix (using mailx) to Lotus Notes addresses.
>
> The output looks formatted on Unix, but when opened in
> Lotus Notes, the formatting is no longer there.
>
> Any Tips?
get them to set the display in Notes to fixed format.;-)
this is a client issue and not a server issue, by default Notes [and
Outlook and some others] display received email in flexable spaced
fonts. changing the display to use a fixed font will solve the
problem.
--
--
Bill "Shrek" Thater ORACLE DBA
shrekdba@xxxxxxxxx
------------------------------------------------------------------------
"Zen is not easy.
It takes effort to attain nothingness.
And then what do you have?
Bupkes." -- The Goddess
--
http://www.freelists.org/webpage/oracle-l
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
http://www.freelists.org/webpage/oracle-l