CSV attachment

[Former Member]

Hi experts.

I've did a report for send mails with an attachment of type CSV.

the problem occured when i tried to open this attachment.

Ms Office raise a message saying that the file cannot be open.

the issue is that if i open this attachment with a text editor like notepad++ the file format is correct!!!!

Any idea??

Best regards

Marco

[Former Member]

Did you name the file with an extension .csv? If so, you would optimally open with Windows Explorer, not Excel, so that the auto import wizard would be invoked and insert the values into a .csv format worksheet, which could then be saved as an Excel Worksheet....

[Former Member]

Hi

I've tried to open the file with explorer but it doesn't work...

any other ideas??

marco

[SimoneMilesi]

What kind of separator are you using?

And what kind of separator is used in Excel to manage CSV?

[Former Member]

Ciao Simone

I'm using semicolon........and if i save a CSV file by excel the separator is still semicolon.

regards

Marco