Simple question about Access form

[Noreene Patrick]

I am working with a database that Safety Director needs to track work orders. She only wants an email every time a new work order is generated.

I already have acquired the vb code to open lotus notes and send attachment.

My problem is that it sends the entire database...this is the line of code that I am not sure of:

set embedobj = attachme.embedobject(1454,"", attachment, "c:\mydocuments.work order.mdb"

I know that I am telling it to send that entire database, but what would the code be for sending the current form?

Something like c:\my documents\work order\work order entry\current ????

Could someone help???

Thanks, Noreene

 

[Calvin]

If all you need to do is send a notification and not neccissarily the entire record nicely layed out on form, then create a custom message and subject concatinating the important peices together, but you do have me at a loss with Lotus Notes, most of my email notifications are using MS Exchange/Outlook.

 

[Noreene Patrick]

Thanks, Calvin
But, I do need to send a "snapshot" of the form so that Director can see problem immediately.

I found the code I needed to open Lotus Notes and send attachment...but, I cant figure how to only send a snapshot of current record...

Can anyone help?