Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / March 2006

Tip: Looking for answers? Try searching our database.

SendObject problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andy_Khosravi@bcbsmn.com - 03 Mar 2006 16:43 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.