MVSFORUMS.com

[pjagadabi]

I am trying to sending a e-mail with excel attachment from mainframe ,i am able to send a excel attachement but all data is coming in one cell ,i want to send as header and detail record by each field in each cell.

i was converted the data in to base64 format and i was used mime commands as
--boundary_characters
Content-Type: application/msexcel;
name= "Fidelity_Holding.xls"
Content-Transfer-Encoding: base64

Please any body can help me

I think i want to generate excel spreadsheet style formate along with data
Please any body know about to generate excel spreadsheet style formate in mainframe

Prakash J

[kolusu]

pjagadabi,

Create a .csv file on the mainframe and send it as text file and upon receiving open the text file with excel and follow the prompts.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[pjagadabi]

Kalusu,

Thanks for your help,it working fine ,now is coming properly in excel with column wise. i used as you said

--boundary_characters
Content-Type: application/text;
name= "Fidelity_Holding.csv"
Content-Transfer-Encoding: 7bit

But i want to make colur and font size for header and detail record
please help me on this

Thanks and Regards
Prakash J