Hi,

I am facing issue with special characters (comma and dot) while using to send email.
This is my sample code. I need to use the company name as file name which might contain special characters.
When I run the below code I am getting (FOC1562) EDAMAIL: FILE 'test.test' NOT FOUND

Can someone please provide solution?

-SET &fileName = 'test.test';
TABLE FILE CAR
PRINT
COUNTRY
ON TABLE HOLD AS '&fileName' FORMAT PDF
END
-RUN

EX EDAMAIL emailtest@gmail.com,,edamail test,A,PDF,'&fileName'

Thank You
Sandhya

This message has been edited. Last edited by: FP Mod Chuck,

1. Your error has nothing to do with special characters
2. NEVER use comma's in a file name
3. Does test.test look like a PDF file to you?
4. EDAMAIL "requires" the file to be stored, not just created in space...
5. SMTP Server has to be setup on the Reporting Server
6. emailtest@gmail.com is a valid address?

Try:

   
-SET &FILENAME = 'test.test.pdf';
TABLE FILE CAR
PRINT
COUNTRY
ON TABLE HOLD AS FOCCACHE/&FILENAME FORMAT PDF
END
-RUN

EX EDAMAIL emailtest@gmail.com,,edamail test,A,PDF, FOCCACHE/&FILENAME
-RUN

Sandhya,

Did you get this working?

Thanks Tom

Yes, this solution is working.
Is there any way to handle single quote (')?

Thanks
Sandhya

Sandhya

Try using ''' for each single tick mark..

Thank You