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.