Send Email in Microsoft Access

Send Email
By Richard Rost

11 months ago

Need Help Upload Images Link
Russ Phillips
4 months ago

Richard
how do you add spaced with out the "......." it wont work if its blank spaces. It looks too mashed together in outlook and what how do I add about 6 more fields
do I need to make more MSG AS Strings

Private Sub Command24_Click()
    
    Dim Msg As String
        
    Msg = "Area / Process" & "......." & AreaProcess & ",

" & _ "Your Statement ballance as of " & Date & " is " & creditlimit

Alex Hedley
4 months ago

What did you try?

Msg = "Area / Process" & " " & AreaProcess &

Msg = "Area / Process " & AreaProcess &

Russ Phillips
4 months ago

Alex
How would I make the text Bold " Your Statement Balance as of" to show in outlook in the button code
some of the stuff I have

Private Sub Command24_Click()

 Dim Msg As String

 Msg = "Area / Process: " & AreaProcess & "," & _
 "Problem Statement: " & ProblemStatement & "," & _
 "Product Affected: " & ProductAffected & "," & _
 "Status: " & Status & "," & _
 "Posted Red Light Date: " & RedLightDate & "," & _
 "Spoc: " & Spoc & "," & _
 "Team Members: " & TeamMembers & "," & _
 "Action:" & Action & "," & _
 "our Statement ballance as of " & Date & " is " & creditlimit

I want all the subs to be bold.
Thanks
Russ

Alex Hedley
4 months ago

Have you set the email as HTML and not TXT?

Alex Hedley
4 months ago

or the newer tags

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Send Email Comments