How could I save as pdf and send email

Hi all,

I use excel2007 and some users have (probably) an old excel version because they can not read my file sent by email. they see letters, numbers, signs- not my table! Is any way to solve this issue? sholud i change something in the code that i use?
Thanks a lot for your help.

this is the code

Please Login or Register  to view this content.

john

Hello John,

If your recipients have an older version of Excel (pre-2007) and your workbook is saved in 2007 format then they won't be able to read the workbook, unless they have the Office 2007 Converter installed or you save the workbook in 95-2003 format.

Hi Ross,
thank you for your prompt response. I'm trying to find a solution on my side, should i save my file before sending? i do not want to do it because it takes time, i wanna send the file via excel...is possible to modify the code to save it such as everybody to see the file (old format, pdf)?! i'm very sorry for this question but i do not know how to do it...

john

What's the plan now? Are you planning to convert to pdf?

I haven't got Outlook express, but maybe a CDO approach will work.