By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,035 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,035 IT Pros & Developers. It's quick & easy.

Sending a Form by e-mail

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
st*************@transport.qld.gov.au (StuartD) wrote in message news:<75**************************@posting.google. com>...
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?


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.
Nov 13 '05 #2

P: n/a
StuartD wrote:
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?

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.
Nov 13 '05 #3

P: n/a
"Mr. Smith" <Mr.Smith@Large> wrote in message
news:40***********************@news.syd.swiftdsl.c om.au...
StuartD wrote:
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?

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.


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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.