topic Re: query about excel email functionality in Application Development and Automation Discussions

query about excel email functionality

Former Member — Fri, 04 Aug 2006 06:41:11 GMT

Hi,

I'm using this FM SO_NEW_DOCUMENT_ATT_SEND_API1 to send excel file as attachment to external emails.

the problem is that in development & quality system the excel attachment is going properly, but in production the excel file is getting hugely misaligned. Is there some other configuration required in this regards to facilitate this. Thanks in advance for the suggestions.

Regards,

Vijay

(P.S - Please don't copy paste code here)

Re: query about excel email functionality

Former Member — Fri, 04 Aug 2006 06:46:51 GMT

it should not come like that. any way try to do this.

as you mentioned the attachment is an Excel file,

just concatenate each field with a ' (aphostrophe). in excel it you say any field '0001232 , means its takes as character & will be by default LEFT-ALLIGNED.

try this out.

for ex:

concatenate ''''

v_field1

into v_field2.

if v_field1 is 123 , after that that willbe '123.

so in excel, the value will be treated as character(as the value is preceded with a ' ) and left aligned.

regards

srikanth

Re: query about excel email functionality

Former Member — Fri, 04 Aug 2006 06:47:53 GMT

Hi friend,

For data to be properly alligned in the Excel file you need to format the data with some characters like,

'09' - for tab

'0D' - for next line etc.,

Try to concatenate these characters with the fields that you pass to the excel file...

Re: query about excel email functionality

Former Member — Fri, 04 Aug 2006 06:49:17 GMT

I've done this 09 and 0D thing. That's what I said - It's working properly in development and quality. But only in PRD I'm having this problem.

Has anybody faced this problem.

Regards,

Vijay