August 4th, 2003, 04:37 PM
|
|
Registered User
|
|
Join Date: Aug 2003
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
On the message spanning two pages you can continue a message using the ampersand and the underscore like this:
Code:
Dim strMess As String
strMess = "This is my first line of my text and " & _
"now I am going to continue a second line " & _
"however the message will appear as a " & _
"complete paragrapgh with out any built in " & _
"carraige returns. The text will wrap depending " & _
"on the size of the email window."
Depending on what you are doing you may want to consider storing your messages in the table and calling them as you need them.
By the way the above code could be used in a SendObject like this:
Code:
Dim strMess As String
strMess = "This is my first line of my text and " & _
"now I am going to continue a second line " & _
"however the message will appear as a " & _
"complete paragrapgh with out any built in " & _
"carriage returns. The text will wrap depending " & _
"on the size of the email window."
DoCmd.SendObject , , , "email@nowhere.com", , , "Subject Line", _
strMess, True
As far as adding a second attachment how are you doing the first?
|
ASP Free Forums Sponsor:
MS Access dilema
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
