S
ServiceEnvoy
I've got a command button that creates an outlook email. I then use
fields from the form to fill in places in the subject and body of the
email. I use so much space in the body of the email that the VBA code
tries to wrap and then it turns red and doesn't work. Is there a way
to use more characters/length/word wrap in VBA code or am I just
trying to make the VBA code do too much?
Example code:
..body = "I have a " & [Task/Problem] & " in " & [City] & ", " &
[State] & " " & [Zip] & " and would like to see if you are available
some time in the next few days. Parts will be onsite and the call pays
a flat rate of $30. If you require a higher rate to do the call,
please reply to this email with your offer. We will take the lowest
qualified offer. Please respond ASAP if you're interested and I can
give you more details." & Chr(13) & "WE REQUEST THAT YOU RESPOND IN
SOME WAY TO THIS MESSAGE. After we attempt to contact a technician 3
times and receive no response, we remove that technician." & Chr(13) &
"If you can't do this call, simply reply to this message and let me
know. I'll notate that you responded and keep you in mind for future
work." & Chr(13) & "If you have moved, remember we do calls
nationwide. Just reply to this email with any updates and we'll update
your profile." (I RUN OUT OF SPACE SOMEWHERE HERE BUT STILL NEED
ENOUGH SPACE FOR ANOTHER SENTENCE AND SPACE FOR MY SIGNATURE)
fields from the form to fill in places in the subject and body of the
email. I use so much space in the body of the email that the VBA code
tries to wrap and then it turns red and doesn't work. Is there a way
to use more characters/length/word wrap in VBA code or am I just
trying to make the VBA code do too much?
Example code:
..body = "I have a " & [Task/Problem] & " in " & [City] & ", " &
[State] & " " & [Zip] & " and would like to see if you are available
some time in the next few days. Parts will be onsite and the call pays
a flat rate of $30. If you require a higher rate to do the call,
please reply to this email with your offer. We will take the lowest
qualified offer. Please respond ASAP if you're interested and I can
give you more details." & Chr(13) & "WE REQUEST THAT YOU RESPOND IN
SOME WAY TO THIS MESSAGE. After we attempt to contact a technician 3
times and receive no response, we remove that technician." & Chr(13) &
"If you can't do this call, simply reply to this message and let me
know. I'll notate that you responded and keep you in mind for future
work." & Chr(13) & "If you have moved, remember we do calls
nationwide. Just reply to this email with any updates and we'll update
your profile." (I RUN OUT OF SPACE SOMEWHERE HERE BUT STILL NEED
ENOUGH SPACE FOR ANOTHER SENTENCE AND SPACE FOR MY SIGNATURE)