I posted this question about two days ago, but for some reason it never
actually got put up. I couldn't' find it with searches, so I am
re-posting it now. I apologize if this is a double post.
Hello,
I've a bit of a problem with the SendObject command in VBA. On my
computer when I execute the below code, a new memo is generated in
Lotus Notes with an attachment labeled "Benefit Issues Log.rtf".
(Benefit Issues Log is the name of the database).
When I test the compiled mde version on my own computer, it works as
advertised. However, a limited number of users experience a strange
anomaly. For these users the mail message is attached as "CDB7A.xls".
(Note: the number portion of the file name increments up by one each
time a new mail message is sent) I have no idea where it's getting the
name CDB7A from, but am not overly concerned with it. My primary
concern is that it's sending it with the extension xls when it needs to
have the rtf extension. Note that the actual output is formatted
internally as an rtf file, and when the extension is changed it opens
correctly. The information displayed in the report is also correct
indicating it is referencing the right report. Unfortunately, most of
my users get glass eyes when I try to explain what an extension is and
how to change it.
In short, I need the below code to always be sending the attachment
with the extension rtf from all machines. Any ideas on how I might get
this to work, or why its not always doing it the same way for
everybody?
OutputType = "RichTextFormat(*.rtf)"
DoCmd.SendObject acReport, "rptmainsingle", OutputType, "", "", "", "",
"", True, ""
I also tried
DoCmd.SendObject acReport, "rptmainsingle", acFormatRTF, "", "", "",
"", "", True, ""
Note: I am using Access 97 with Lotus Notes 6.5
Thanks in advance for any help any of you may be able to provide.
MGFoster - 03 Mar 2006 20:00 GMT
I'd use the intrinsic constant acFormatRTF instead of your manufactured
output type. Your syntax for the SendObject method is incorrect: you
don't need the empty strings for unused parameters; therefore your
command should look like this:
DoCmd.SendObject acReport, "rptmainsingle", acFormatRTF, , , , , , True
You may want to review the Lotus Notes documentation about attachments
to find out why the file name is changing.
There may be a solution on the WEB that shows how to use VB or VBA to
use Lotus Notes mail progam. Like this site:
http://www.fabalou.com/VBandVBA/lotusnotesmail.asp
which I got from a search on Google (about 218,000 hits). The search
string:
"lotus notes" mail VB VBA

Signature
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
> I posted this question about two days ago, but for some reason it never
> actually got put up. I couldn't' find it with searches, so I am
[quoted text clipped - 36 lines]
>
> Note: I am using Access 97 with Lotus Notes 6.5
Andy_Khosravi@bcbsmn.com - 03 Mar 2006 21:00 GMT
Thanks for the suggestion, I'll try that out