Exporting Access form to Outlook formatting

[brownpride]

I have been successful in exporting the active record in PDF format to Outlook for e-mail using VBA. I have added text to the email. However when the message text exports to Outlook the 1st line is blank and the text starts on the 2nd line. For example...



Message Text:
"Unwanted Empty Line"
"Dear...."
""
"Please..."

How can I have the "Dear..." start on the 1st line of the e-mail (instead of the 2nd line) without manually formatting the e-mail?

Code is below.

Sub Send_Click()Dim strDocName As String
Dim strWhere As String
    strDocName = "frmInvoice"
    strWhere = "[B]=" & Me.B
    DoCmd.ApplyFilter cPreview, strWhere
Dim mailto As String
Dim emailmsg As String
mailto = [Invoice Contact - E-mail]
emailmsg = "Dear " & [Invoice Contact - First Name] & " " & [Invoice Contact - Last Name] & "," & vbCrLf & vbLf & _
"Please..."
DoCmd.SendObject acSendForm, "frmInvoice", acFormatPDF, mailto, , , mailsub, emailmsg, True
End Sub

[ItsMe]

You want a form or report to appear in the Body of your email? There may be a new fangled way to do this. However, I have always used VBA to generate HTML code and store the HTML code in a String Variable. Then apply that to the Outlook Mail Object's .Body property.

[brownpride]

You want a form or report to appear in the Body of your email? There may be a new fangled way to do this. However, I have always used VBA to generate HTML code and store the HTML code in a String Variable. Then apply that to the Outlook Mail Object's .Body property.

No, I just want text that I type in. The form is already attached as a .pdf

I have seen some forums about using outlook mail objects, but I have been unsuccessful at using it while keeping the same exact function.

[ItsMe]

I am not sure why you are getting that initial line feed and carriage return. There may not be anything you can do about that. If you want to add a carriage return, I would do it the way you are ... vbcr or vbCrLf

I almost always use automation of Outlook. Here is an example if you are interested.
https://www.accessforums.net/showthr...258#post281258

[brownpride]

Is there a way to have the PDF attached directly to the e-mail without saving it in a folder first (using the code you linked)?

[ItsMe]

I do not believe so. I will guess that even the DoCmd will generate the file and store it somewhere in a systems folder prior to moving it to Outlook.