Hello,

I am unable to insert MAPI controls in my forms to enable email in my 

application.  As soon as I try to insert the MAPI Message / Session 

controls message "OLE server not registered" props up.  I tried to 

register MsMapi32.ocx by using the command "regsvr32 msmapi32.ocx" but 

this has not helped either.  It appears that I will be unable to insert 

the controls unless I load VB in my machine.  Is their a way that can 

allow me to insert the MAPI controls without loading VB in my machine.  

Any help will in this regard will be appreciated.







Programmer

Hello,



Thanks for the advice.  The problem with using DoCmd.SendObject command is

that it will not allow me to send a text file as an attachment that doesnot

reside in the database.  In fact in my application I want to send a text

file in another directory/folder as an attachment,  for this purpose I was

trying to use MAPI controls in MS-Access form.  Is there a DoCmd action that

will allow me to send an attachment.  Secondly I would also like  my

MS-Access application to receive e-mail and be able to read attachment

file(s) if any.  Perhaps this may not be possible without using MAPI

controls.  As mentioned in my earlier email I have not been able to insert

MAPI controls in absence of VB on my machine.   On a machine with VB loaded

the MAPI controls get inserted.  I would like to know if the above tasks can

be accomplished without loading VB on my machine and if possible without

MAPI controls.





Programmer



Original Message -----

From: "Derrick Flores" <Derrick_Flores@s...>

To: "Access" <access@p...>

Sent: Friday, October 12, 2001 7:01 PM

Subject: [access] Concealed





Subject:  Re: [access] Using MAPI controls on MS ACCESS 2000 forms



You can use another method of sending emails from Access.  I use the

docmd.SendObject to send reports or just messages or alerts.  This works

great with any MAPI environment like MS Outlook and Novell GroupWise.

Here are some samples:

I assign variables (sendTo, SendCC, sendSubject and sendMessage) with the

information gather from the form and place them in my code.



To send a report:

DoCmd.SendObject acReport, "rptName", "RichTextFormat(*.rtf)", sendTo,

SendCC, "", sendSubject, "This Report You Need To See", False, ""



To send a message:

DoCmd.SendObject , , , sendTo, sendCC, "", sendSubject, sendMessage, False,

""



I use this method so I don't have to worry about any ocx that are not loaded

on each computers.



Good Luck,







Derrick A. Flores

Sony Semiconductor

Assoc. Systems Engineer

66318



>>> "Computer Cell" <rbcc@r...> 10/12 3:14 AM >>>

Hello,

I am unable to insert MAPI controls in my forms to enable email in my

application.  As soon as I try to insert the MAPI Message / Session controls

message "OLE server not registered" props up.  I tried to register

MsMapi32.ocx by using the command "regsvr32 msmapi32.ocx" but this has not

helped either.  It appears that I will be unable to insert the controls

unless I load VB in my machine.  Is their a way that can allow me to insert

the MAPI controls without loading VB in my machine.  Any help will in this

regard will be appreciated.







Programmer

Hi



I've an old 'Smart Access' article, along with sample database, that 

covers this (and allows Access to process received emails). It uses 

automation code to run Outlook from an Access session.



Drop me a line if you're interested.



Brian



-----Original Message-----

From:	programmer [SMTP:rbcc@r...]

Sent:	15 October 2001 05:37

To:	Access

Subject:	[access] Re: Using MAPI controls on MS ACCESS 2000 forms



Hello,



Thanks for the advice.  The problem with using DoCmd.SendObject command 

is

that it will not allow me to send a text file as an attachment that 

doesnot

reside in the database.  In fact in my application I want to send a text

file in another directory/folder as an attachment,  for this purpose I 

was

trying to use MAPI controls in MS-Access form.  Is there a DoCmd action 

that

will allow me to send an attachment.  Secondly I would also like  my

MS-Access application to receive e-mail and be able to read attachment

file(s) if any.  Perhaps this may not be possible without using MAPI

controls.  As mentioned in my earlier email I have not been able to 

insert

MAPI controls in absence of VB on my machine.   On a machine with VB 

loaded

the MAPI controls get inserted.  I would like to know if the above tasks 

can

be accomplished without loading VB on my machine and if possible without

MAPI controls.





Programmer

You can use the docmd.SendObject to attached a report in your database, 

now if you want to attached a document from another directory (other that 

accesss) then you can set the second to last setting in your docmd 

statement to True which will bring the email up in view so you can 

attached or add on to your email.



Try that,





Derrick A. Flores

Sony Semiconductor

Assoc. Systems Engineer

66318



>>> Brian Skelton <brian.skelton@b...> 10/15 6:41 AM 

>>>



Hi



I've an old 'Smart Access' article, along with sample database, that 

covers this (and allows Access to process received emails). It uses 

automation code to run Outlook from an Access session.



Drop me a line if you're interested.



Brian



-----Original Message-----

From:	programmer [SMTP:rbcc@r...]

Sent:	15 October 2001 05:37

To:	Access

Subject:	[access] Re: Using MAPI controls on MS ACCESS 2000 forms



Hello,



Thanks for the advice.  The problem with using DoCmd.SendObject command is

that it will not allow me to send a text file as an attachment that doesnot

reside in the database.  In fact in my application I want to send a text

file in another directory/folder as an attachment,  for this purpose I was

trying to use MAPI controls in MS-Access form.  Is there a DoCmd action that

will allow me to send an attachment.  Secondly I would also like  my

MS-Access application to receive e-mail and be able to read attachment

file(s) if any.  Perhaps this may not be possible without using MAPI

controls.  As mentioned in my earlier email I have not been able to insert

MAPI controls in absence of VB on my machine.   On a machine with VB loaded

the MAPI controls get inserted.  I would like to know if the above tasks can

be accomplished without loading VB on my machine and if possible without

MAPI controls.





Programmer

Brian,



I would be interested in that article too.  I have a project coming up

where e-mail/text files will be part of the system.



Thanks,



vlad

hi Brian,

I am interested in that article

Please forward the article to me too

Thanks for your contribution in advance.



----- Original Message -----

From: "Brian Skelton" <brian.skelton@b...>

To: "Access" <access@p...>

Sent: Monday, October 15, 2001 05:41 PM

Subject: [access] Re: Using MAPI controls on MS ACCESS 2000 forms





Hi



I've an old 'Smart Access' article, along with sample database, that covers

this (and allows Access to process received emails). It uses automation code

to run Outlook from an Access session.



Drop me a line if you're interested.



Brian



-----Original Message-----

From: programmer [SMTP:rbcc@r...]

Sent: 15 October 2001 05:37

To: Access

Subject: [access] Re: Using MAPI controls on MS ACCESS 2000 forms



Hello,



Thanks for the advice.  The problem with using DoCmd.SendObject command is

that it will not allow me to send a text file as an attachment that doesnot

reside in the database.  In fact in my application I want to send a text

file in another directory/folder as an attachment,  for this purpose I was

trying to use MAPI controls in MS-Access form.  Is there a DoCmd action that

will allow me to send an attachment.  Secondly I would also like  my

MS-Access application to receive e-mail and be able to read attachment

file(s) if any.  Perhaps this may not be possible without using MAPI

controls.  As mentioned in my earlier email I have not been able to insert

MAPI controls in absence of VB on my machine.   On a machine with VB loaded

the MAPI controls get inserted.  I would like to know if the above tasks can

be accomplished without loading VB on my machine and if possible without

MAPI controls.





Programmer

Hello Brian,



I would like to have the article.  Please forward the same to me.  Thank you

in advance.



Programmer