Email content of fields on a record, using MS-Outlook

[DonDaniel]

Hello:
I'm working with a table containing a series of fields that include 2 memo fields. Using a form I add one record at a time, and these fields get populated; once the task is finished, I'd like to copy the content of these memo fields into the body of an Outlook email msg. so I can complete the task this table has been designed for.

On the form, I have a link that can call Outllook, however, I haven't found a way to transfer the content of these fields to my e-mail msg.

My VB is really poor (NIL, I'd say).

Any suggestions are more than welcome.

[MMcCarthy]

Please post the code you are currently using to email to outlook as well as the control names of the two memo fields.

[DonDaniel]

Please post the code you are currently using to email to outlook as well as the control names of the two memo fields.

*
Hi, Thanks for replying.
To email to Outlook, I have inserted a hyperlink to the form, when I click on it, Outlook opens with a new message. The control names for the memo fields: "original_pmnt" and "documentation".

[MMcCarthy]

You will need to use code to send your email. There are a number of previous questions on this topic. Check out some of the following:


http://www.thescripts.com/forum/thread630972.html
http://www.thescripts.com/forum/thread644508.html
http://www.thescripts.com/forum/thread609479.html
http://www.thescripts.com/forum/thread630337.html

[DonDaniel]

Hello and thanks again.
I was able to write some code and now that I have the required text on the email body, I'd like to know if I can change the font size, bold it and underline it.
Any suggestions?

Here's the code I'm using to populate the email body:

Private Sub Command33_Click()
On Error GoTo Err_Command33_Click

Dim stMemoField1 As String
Dim stMemoField2 As String
Dim stAccount As String
Dim stHeader1 As String


stMemoField1 = documentation
stMemoField2 = original_pmnt
stAccount = account
stHeader1 = "Copy of Return Wire"


DoCmd.SendObject , , , , , , "Return of Funds - Your acc.: " & stAccount, stHeader1 & Chr$(13) & stMemoField1 & Chr$(13) & Chr$(13) & stMemoField2

Exit_Command33_Click:
Exit Sub

Err_Command33_Click:
MsgBox Err.Description
Resume Exit_Command33_Click

End Sub

[MMcCarthy]

As far as I know this isn't possible but it may be that some of the other experts know of a way. I would suggest posting a new thread with this code and asking the question.