emailing

  • Thread starter Thread starter Hepburn
  • Start date Start date
H

Hepburn

From single record view of a form (my prospects), I want
to create an event in which I email a standard letter to
that prospect (either a .doc attachment, a standard
message or a single record report, which ever is easiest)
It's just a simple letter of introduction and not even
mail merged. I will have just entered the prospect's email
address onto the form.

Any suggestions or code I can copy for this simple process?

Hepburn
 
Access will allow you to email a report written in Access
but will attach it to an email in several different
formats. You can make a macro or build code to perform
this action.

Code would be something like:

Function EmailLetter()
On Error GoTo EmailLetter_Err

DoCmd.SendObject
acReport, "rptDocMasterList", "RichTextFormat(*.rtf)",
Forms!MyForm!ProspectEmailAddress, "", "", "This goes on
the subject line", "", False, ""

EmailLetter_Exit:
Exit Function

EmailLetter_Err:
MsgBox Error$
Resume EmailLetter_Exit

End Function

If you use a macro:

Use =Forms![MyForm]![ProspectEmailAddress] on the "To"
line of the SendObject action
 
-----Original Message-----
Access will allow you to email a report written in Access
but will attach it to an email in several different
formats. You can make a macro or build code to perform
this action.

Code would be something like:

Function EmailLetter()
On Error GoTo EmailLetter_Err

DoCmd.SendObject
acReport, "rptDocMasterList", "RichTextFormat(*.rtf)",
Forms!MyForm!ProspectEmailAddress, "", "", "This goes on
the subject line", "", False, ""

EmailLetter_Exit:
Exit Function

EmailLetter_Err:
MsgBox Error$
Resume EmailLetter_Exit

End Function

If you use a macro:

Use =Forms![MyForm]![ProspectEmailAddress] on the "To"
line of the SendObject action
-----Original Message-----


From single record view of a form (my prospects), I want
to create an event in which I email a standard letter to
that prospect (either a .doc attachment, a standard
message or a single record report, which ever is easiest)
It's just a simple letter of introduction and not even
mail merged. I will have just entered the prospect's email
address onto the form.

Any suggestions or code I can copy for this simple process?

Hepburn
.
Click to expand...
.
Thanks Bob,
Click to expand...

I'll put that to use immediately.

My only response is that I think I was miss understood. In
my effort to make my inquiry succinct I phrased part of my
question wrong.

In what format would the letter be easiest to work with?
1. A word doc to attache (it's current format)
2. A report
3. Something of which I'm unaware

Also, how does this work mechanically? Does it open
Outlook or Express and if it uses them where are the
records of this event stored?

Thanks,

Bill
 
Back
Top