I need to Email one record from my database. 1

[MullinsFan]

All I need is to email one record from my database. "InvoiceN" is my only unique qualifier on each record. My database name is "FulfillmentOrderDatabase", my form name is "FulfillmentOrderInterface" and my report name is "rptPrintRecord".

It would be great if someone could give me a hand on this.

This thread was helpful but not quite enough. I can't quite get the pieces put together right.

thread703-415389

Thanks ahead of time,
Hal S.

 

[cghoga]

try this.

DoCmd.SendObject acReport, "rptPrintRecord", "SnapshotFormat(*.snp)", "intendeesemailaddress", "", "", "SubjectGoesHere", "MessageTextGoesHere", False, ""

To send to maore than one email address seperate each address with a ";" semicolon.

False indicates that you do not want to edit the email before it sends it. Otherwise, True, stops the email, and lets you edit it before sending.

Hope this helps.

 

[MullinsFan]

Thanks for the help, unfortunately I need to send just one record and this includes them all. This database could potentially end up being quite large. So, if I could get it to send just one record, probably in html format, then it won't include everything.

Thanks,
Hal S.

 

[SuicidED]

Base your report on on a query that the criteria is InvoiceN
equals Forms!FulfillmentOrderInterface!InvoiceN (if thats the name of the box on the form). Then do as above with the send object (use a command button on the form FulfillmentOrderInterface to call this) and it will only send the current record.