Email snapshot, how to auto subjectfiled

[maes2]

Hi !
I want to send a report of a document (snapshot) with e-mail. (Access2000)

In every report there is a new "serialnumber" that I want to end up in the subjectfield of the email.

The recever of the e-mail is always the same person, the problem is the subject.

Does anyone know how the code look like, they want to just press a button, (we use outlook2000/Exchange).

//ME

 

[LonnieJohnson]

One way would be is to put a DLookup statement in the subject line for the query that feeds the report.

DoCmd.SendObject acSendReport, "ReportName", acSnapshot, "joe@mail.com", , , DLookup("SerialNumber", "MyQueryName&quot prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.