IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

mail attachment with excel format


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
nani821

New User


Joined: 07 Nov 2022
Posts: 4
Location: India

PostPosted: Wed Nov 16, 2022 10:05 pm
Reply with quote

Hi All,

I am trying to send a mail with excel attachment. I am using the IBMGENER with below code, bit I am getting text email without attachment. Please help me to send a mail with excel attachment

HELO TSOM.uboc.com
MAIL FROM: <XXXX@XXXX.COM>
RCPT TO: <XXXX@XXXX.COM>
DATA
FROM: <XXXX@XXXX.COM>
SUBJECT :"Data-dump"
--boundary_characters
CONTENT-TYPE: application/msexcel;
name= "data.xls"
Content-Transfer-Encoding: 64bit


My data file has:
NAME|PLACE|ZIPCODE|PH NUM|
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8661
Location: Dubuque, Iowa, USA

PostPosted: Thu Nov 17, 2022 5:58 am
Reply with quote

First problem: you created your topic in the Mainframe Jobs forum. Your post has nothing to do with mainframe jobs, so I moved it.

Second problem: unless you have a mainframe program that can generate Excel format, you will NOT, under any circumstances, be able to get an Excel attachment through the send. You CAN do comma-delimited, which Excel recognizes -- but it is not an .xlsx or .xls formatted file. A comma-delimited file can only contain a single workbook (tab).

Third problem: in order to send an attachment, you must follow the SMTP rules and you have not done so. If you do a search in this forum, you can find several posts I did some years back explaining how to send an attachment to an SMTP message. One thing that MUST be stressed, though, is that sending attachments in SMTP is extremely sensitive to formatting. The spacing, blank lines, and separator lines must be precisely done or the attachment won't be sent. If you find the posts, follow their rules, and experiment some you can get attachments to send.
Back to top
View user's profile Send private message
nani821

New User


Joined: 07 Nov 2022
Posts: 4
Location: India

PostPosted: Thu Nov 17, 2022 10:14 am
Reply with quote

Thank you for the update, will check in other posts.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Converting fixed length file to excel... IBM Tools 7
No new posts Select a DB2 value in a specific deci... DB2 4
No new posts To re-format the file using SORT card DFSORT/ICETOOL 8
No new posts Printing a dataset in DUMP format wit... ABENDS & Debugging 2
No new posts Converting a file from PD to display ... SYNCSORT 4
Search our Forums:

Back to Top