Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: how to send a fixed-format mail from unix
Sure, I sent this example earlier:
cat message.txt | expand | mailx -s "Test message" you_at_yourdomain.com
The "*with*" isn't part of the command - I was just trying to emphasize the difference in the second example.
Let me know if you have any questions.
-----Original Message-----
From: Deepak Sharma [mailto:sharmakdeep_oracle_at_yahoo.com]
Sent: Friday, July 29, 2005 10:18 AM
To: Allen, Brandon; shrekdba_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: RE: how to send a fixed-format mail from unix
Allen,
Can you pls give an example how to send an email from Unix using the *with* expand command?
Thanks,
Deepak
> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
> bill thater
> Sent: Friday, July 29, 2005 4:45 AM
> To: sharmakdeep_oracle_at_yahoo.com
> Cc: oracle-l_at_freelists.org
> Subject: Re: how to send a fixed-format mail from
> unix
>
>
> On 7/28/05, Deepak Sharma
> <sharmakdeep_oracle_at_yahoo.com> 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_at_gmail.com
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 29 2005 - 12:21:52 CDT
![]() |
![]() |