attachment is unreadable in LN mail

[XB9R]

Hi all,

I have some VBA code to send a Lotus Notes email from MS Access. The code has the ability to attach a file. Code works fine : it creates & sends the email. There's only one issue: when attaching anything else than an .TXT file the file is unreadable for the mail-recepients.
I'm using some code wich is very familiar to this forum.

Call Body.EMBEDOBJECT(1454, "", "C:\MyFile.xls", "Attachment")

I have no idea why and can't seems to find anything on search.

help appreciated.

Dave

 

[XB9R]

No ideas ? Nobody ?

Dave

 

[m4ilm4n]

How does the attachment arrive - is it still tagged as a .xls extension? When you say unreadable, what exactly is the client doing - refusing to open it or opening it but returning garbage?

 

[XB9R]

Sorry, i've been away for a while. Now I'm back.

The file is still tagged as .xls.

On opening LN displays a message : This file is not in a recognizable format.
You can however select to open the file. The file is then displayed reading something like :

–6h3Â.
Ä4á@!GÀ
üÿ€Ñx,C0öB>÷ü8 ì†D :È

(only first 2 rows as example)




Dave

 

[m4ilm4n]

Been away a bit meself. The only things I can think of are either the program association with the .xls extension has been lost (possibly in the registry) or the Notes client's Unicode settings are incorrect.

 

[XB9R]

OK, I need to give more info:
° When the attachment is created 'manualy' it sends fine & opens without any error/remark.
° When sending the same excel-file through VBA I get the above error.

I would like to think that a missing/incorrect registry entry would also affect the manual approach. (please correct me if wrong)

Same thinking about the Unicode settings - although I'm not experienced in this domain.

Any further thought ?


Dave

 

[m4ilm4n]

The only thing that comes to mind is that the VBA version may be taking a different path than the manually-created one, i.e. I'm thinking the VBA version is sent with a MAPI DLL where the manual one uses a Notes DLL? Just shooting in the dark, but it's the only difference I can see in the two methods.