Back to basics!
Original problem - persuading Access 97 to send an object (a report in this
case) in an email.
It is supposed to do this by including it as an attachment.
THis is what Access HELP provides:
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
You can use the SendObject action to include the specified Microsoft Access
datasheet, form, report, or module in an electronic mail message, where it
can be viewed and forwarded. You can include objects in Microsoft Excel 97
(*.xls), MS-DOS text (*.txt), rich-text (*.rtf), or HTML (*.html) format in
messages for Microsoft Exchange, Microsoft Mail, Microsoft Windows for
Workgroups mail, or another electronic mail application that uses the
Microsoft Mail Applications Programming Interface (MAPI).
If you have an electronic mail application that uses the Vendor Independent
Mail (VIM) protocol and have installed and set up the dynamic-link library
(Mapivim.dll) that converts MAPI mail messages to the VIM protocol, you can
send Microsoft Access objects to the VIM mail application.
::::::::::::::::::::::::::::::::::::::::::::::::::::::
HOWEVER - there is alos help on the SEND METHOD
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][,
bcc][, subject][, messagetext][, editmessage][, templatefile]
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
With ACCESS 2000 [I have latterly discovered] this works! Opens Outlook
Express with a new Mail message with the object inserted as an attachment
and the other details in the arguments set up.
However, Access 97 compalins - "Can't open the mail session - Check your
mail application to ensure that it's working properly"
I run Access 97 & Access 2000 on the same machine. To acieve this I have 2
new file types .AC7 for access 97 applications and .Md2k for access 2000
applications. The standard access extension is .mdb .
What I have tried -
reinstall access97,
reinstall OuitLook Express 6,
invent Md97 as a file type for access 97 (incase the system is using .Md* to
recognise access database applications)
revert to .mdb for access 97 applications
- all to no avail. 2000 works 97 doesn't
NB the help file info above is from access 97!
"Daniel Chang [MSFT]" <a-(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Outlook needs to be installed ... (I don't think Outlook Express has that
> functionality).
>
> You can call Microsoft and request the following fix (you may obtain it
free
> of charge, however there is no support for this product, and it doesn't
work
> with XP) Just tell the CREP you'd like to obtain a hotfix:
>
> 254458 Windows 2000 Does Not Include Windows Messaging by Default
> http://support.microsoft.com/?id=254458
>
> To resolve this issue, contact Microsoft Product Support
> Services to obtain Windows Messaging for Windows 2000. For information
> about
> how to contact Product Support Services, see the following Microsoft
Web
> site:
>
> http://support.microsoft.com/directo...asp?sd=gn&fr=0
>
> NOTE: Windows Messaging is supplied as is with no product support. It
> is supplied to aid in migrating to later technologies that replace
> Simple MAPI.
> You can also get MAPI support by installing a client such as Microsoft
> Outlook
> 2000 in Corporate or Workgroup mode.
>
>
>
> --
> --
> Daniel Chang
> Server Setup Team
>
> Search our Knowledge Base at http://support.microsoft.com/directory
> Visit the Windows 2000 Homepage at
> http://www.microsoft.com/windows2000/default.asp
> See the Windows NT Homepage at http://www.microsoft.com/ntserver/
>
> NOTE: Please reply to the newsgroup and not directly to me. This allows
> others to add to and benefit from these threads and also helps to ensure a
> more timely response. Thank you!
> This posting is provided "AS IS" without warranty either expressed or
> implied, including, but not limited to, the implied warranties of
> merchantability or fitness for a particular purpose.
> The views and opinions expressed in this newsgroup posting are mine and do
> not necessarily express or reflect the views and / or opinions of
Microsoft.
>
>
> "J Bunton" <(E-Mail Removed)> wrote in message
> news:x7etb.20$(E-Mail Removed)...
> > Thanks for your response:
> > This is the Windows Help Response to Mapi
> > It does say that outlook is required but I do have outlook installed.
> >
> > Any other suggestions please?
> >
> > -------------------------------------------
> > To add fax mail transport service to a profile
> >
> > 1.. Click Start, point to Settings, click Control Panel, and then
> > double-click Mail.
> > 2.. On the Services tab, click Add.
> > 3.. In the Add Service to Profile dialog box, click Fax Mail
Transport,
> > and then click OK.
> > 4.. Click Show Profiles, click the profile in which you want to add
the
> > service, and then click Properties.
> > 5.. Click Add, click Fax Mail Transport, and then click OK.
> > 6.. Repeat steps 4 and 5 for each profile in which you want to add
this
> > service.
> > Notes
> >
> > a.. A fax device must be installed on your computer to add fax mail
> > transport service to a profile.
> > b.. One e-mail profile must be set up in order to add a service.
> > c.. Mail only appears if you have a fax-compatible e-mail program
(like
> > Microsoft Outlook or Exchange) installed on your system
>
> --------------------------------------------------------------------------
> --
> > ------------------------------------
> >
> >
> > "Scott Harding - MS MVP" <scrockel@**NOSPAM**hotmail.com> wrote in
message
> > news:(E-Mail Removed)...
> > > There is no mail transfer service. You can install IIS and use the
SMTP
> > > service from that I believe if that's what your after. This 'Mail'
icon
> I
> > > beleive is installed when you install a MAPI email program like
Outlook.
> > >
> > > --
> > > Scott Harding
> > > MCSE, MCSA, A+, Network+
> > > Microsoft MVP - Windows NT Server
> > >
> > > scrockel@***No_SPAM***hotmail.com
> > > "J Bunton" <(E-Mail Removed)> wrote in messageI have
> > > news:y68tb.6069$_(E-Mail Removed)...
> > > > Seting up Mail Transport Service
> > > > Windows 2000 Professional
> > > >
> > > > Help instructions are:-
> > > > Click:- Start > Settings > Control Panel > Mail The latter doesn't
> > > appear
> > > > to exist
> > > >
> > > > More help if possible please!
> > > >
> > > > --
> > > > Jim Bunton
> > > > (E-Mail Removed)
> > > > 13 Westbourne Road
> > > > Trowbridge
> > > > Wilts. BA14 0AJ
> > > > Tel: 01225 765 541
> > > > Mobile: 07919 283 968
> > > >
> > > >
> > > >
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003
> > > >
> > > >
> > >
> > >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003
> >
> >
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003
Similar Threads
