Sending a Form by e-mail

I have developed an Access database and wish to e-mail a form to a
central address advising of changes etc.
Have the form and command button the form with a macro behind using
SendObject command.

When I use the command button, the program opens Lotus Notes, inserts
the correct e-mail address but does not attach the form.

If I send the e-mail, I get the covering message but no attachment.

Can anybody advise?

re: Sending a Form by e-mail

stuart.r.deaves@transport.qld.gov.au (StuartD) wrote in message news:<751c22ff.0406162111.2a022bcc@posting.google. com>...[color=blue]
> I have developed an Access database and wish to e-mail a form to a
> central address advising of changes etc.
> Have the form and command button the form with a macro behind using
> SendObject command.
>
> When I use the command button, the program opens Lotus Notes, inserts
> the correct e-mail address but does not attach the form.
>
> If I send the e-mail, I get the covering message but no attachment.
>
> Can anybody advise?[/color]

Create a report that looks like the form and send that? Then just
pass the recordID in the filter of the report and mail that.

re: Sending a Form by e-mail

StuartD wrote:
[color=blue]
> I have developed an Access database and wish to e-mail a form to a
> central address advising of changes etc.
> Have the form and command button the form with a macro behind using
> SendObject command.
>
> When I use the command button, the program opens Lotus Notes, inserts
> the correct e-mail address but does not attach the form.
>
> If I send the e-mail, I get the covering message but no attachment.
>
> Can anybody advise?[/color]


Quite simply, you can't .

The best you would be able to do is either of the following and neither
are very glamourous:


1 - Use SendKeys to take a screen shot of the form (Alt+PrtSc captures
just the active form) the use SendKeys again to paste the captured image
into the email body.

Clunky but it would work.


2 - Use code to read the data from the forms record source and formally
write it into the email body.

No formatting to speak of so it is just delivering data in plain text.
Much neater but (programatically) but pretty bland.


As I said not glamorous but if you absolutely HAVE to get the data into
the email body it's probably your only option.

If you want code for number 2 just ask and I'll find it.

The reason you can't do what you're trying is because you are
effectively trying to embed a native Access object into a Lotus notes
email and I think you'll find Notes has no provision for the inclusion
of Access objects. Even if it did, it'd be un-wise to expect that the
recipients' Email program would be able to accomodate an embedded Access
object. Even in an HTML format email.

Good luck.

re: Sending a Form by e-mail

"Mr. Smith" <Mr.Smith@Large> wrote in message
news:40d7a9e4$0$29882$61ce578d@news.syd.swiftdsl.c om.au...[color=blue]
> StuartD wrote:
>[color=green]
> > I have developed an Access database and wish to e-mail a form to a
> > central address advising of changes etc.
> > Have the form and command button the form with a macro behind using
> > SendObject command.
> >
> > When I use the command button, the program opens Lotus Notes, inserts
> > the correct e-mail address but does not attach the form.
> >
> > If I send the e-mail, I get the covering message but no attachment.
> >
> > Can anybody advise?[/color]
>
>
> Quite simply, you can't .
>
> The best you would be able to do is either of the following and neither
> are very glamourous:
>
>
> 1 - Use SendKeys to take a screen shot of the form (Alt+PrtSc captures
> just the active form) the use SendKeys again to paste the captured image
> into the email body.
>
> Clunky but it would work.
>
>
> 2 - Use code to read the data from the forms record source and formally
> write it into the email body.
>
> No formatting to speak of so it is just delivering data in plain text.
> Much neater but (programatically) but pretty bland.
>
>
> As I said not glamorous but if you absolutely HAVE to get the data into
> the email body it's probably your only option.
>
> If you want code for number 2 just ask and I'll find it.
>
> The reason you can't do what you're trying is because you are
> effectively trying to embed a native Access object into a Lotus notes
> email and I think you'll find Notes has no provision for the inclusion
> of Access objects. Even if it did, it'd be un-wise to expect that the
> recipients' Email program would be able to accomodate an embedded Access
> object. Even in an HTML format email.
>
> Good luck.[/color]

As Pieter Linden suggested in the "...Crystal Reports...' thread, you might
be able to kludge this by printing your form (better to create a proper
report, but still do-able) as a PDF -> Save to disk -> attach the PDF to the
email.

HTH
Doug

--
Remove the blots from my address to reply