Sending an excel file as an attachment in a mail

vimali balakrishnan · Post by **vimali balakrishnan** » Tue Mar 01, 2005 2:39 am

Hi,

I tried sending an excel file (.xls,.csv) as an attachment in a mail.There is an option called Attachments in notification activity of DataStage version 7.5.But I couldn't get that excel file thro' my mail.I am able to send .txt files as an attachment in notification activity.Can you clarify me?????

Thanks,
Vimali.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Mar 01, 2005 3:32 am

Try renaming your xls as txt and run the same. If it works then there is problem with xls else with the mechanism.

The file to be attached must reside in the DataStage server.

garthmac · Post by **garthmac** » Tue Mar 01, 2005 6:17 am

You can run a shell script containing the following:

(uuencode /WorkingDirectory/Source.csv Target.csv ) | mail -s "Email Subject" whoever@acme.com

vimali balakrishnan · Post by **vimali balakrishnan** » Wed Mar 02, 2005 1:33 am

Since DataStage works only when the excel file is a .CSV file.So I tried mailing an excel file(.CSV),it worked for me.So I'm able to send a .csv file as well as .txt file thro' notification activity.

Thanks,
Vimali.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Mar 02, 2005 3:22 am

E-mail attachments has nothing to do with DataStage processing that file. You can even e-mail any system files using the DataStage notification stage.

trokosz · Post by **trokosz** » Wed Mar 02, 2005 9:20 pm

DataStage SendMail does not support attachements....You would need to revert to activating Unix MailX to accomplish what you desire

chulett · Post by **chulett** » Wed Mar 02, 2005 9:54 pm

Actually, it does - in 7.5 - which the OP seems to have.