using send object to send a specific record in a report

B

Barry Phillips

I have a report which I would like to send an indivual record to a recepiant.
I have the code below which takes the email address from the Form and inputs
it in the To field. The problem I am having is this the report with every
record shown (several pages) I want to send the report for only the ID
(primary key) on the open form. Below is the code I am currently using to
send the report.

Any help with this would be greatly appreciated.

Dim strEmail As String


If Me.Dirty Then 'save any edits
Me.Dirty = False
End If

If Me.NewRecord Then
MsgBox "Select a record to view."
Else
strEmail = "" & Me.(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help to email reports in snp files 0
acFormatXLS Works in 2003 not 2007 1
email as a pdf 1
docmd send object sending all records to each person 1
email forms and reports 1
Current Record 2
Docmd Send Object - multiple CC fields from a form 3
List all records 0

Top