Excelfile send via LotusNotus using VBA is not opening

[XB9R]

Hi all,

I'm using some code to send an Email with an attachement. We are using Lotus Notes 7 and Excel 2003.

the code:

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

It sends fine, only the file can't be opened by the receiver. Only TXT-files can be opened. Any other extension won't open (at least not in a readable format)

Any ideas?


Dave

 

[kjv1611]

Access not involved. You need to ask that question here:
forum707

Well, I'm assuming here that the code is within Excel, not Notes. If within Notes, then you need to find another forum for dealing with their code, as I don't believe it's the same:
forum73

 

[XB9R]

Thx for pointing me to 2 valuable forums - can't remember what made me post in this forum...

Well actually the code is in Access (VBA) We're trying to send a Lotus Notes mail with an excel file attached to it.
The code works fine when we attach a text file. Attaching any file with a different extension than .TXT results in a mail with attachment. The attachment can be opened, but is not in the expected format - it is unreadable ...





Dave

 

[kjv1611]

Hmm, if the code is working other than the readable format, then perhaps there's another issue at hand. I've never used Lotus mail, so I can't really guess at that. If it were me, I'd first be looking up something like:
Excel Data Corruption Lotus Mail

However, be aware, it seems that search brings mostly results such as "Buy My Data Recovery Software" from multiple vendors. You may have to go a couple pages deep to get good results on that...