objEmail.HTMLBody inserting "! " characters into e-mail

L

Leo Mansi

I have code in a module that is sending e-mails, the content of which varies
beased upon the content of fields within the database. I am creating the
body using a number of string variables and then concatenating them together
and assigning them to the objEmail.HTMLBody object similar to this:

CompleteBody = Body1 & Body2 & Body3 & Body4
objEmail.HTMLBody = CompleteBody

Originally, I wasn't using so many variables, but have modifed the code to
try to resolve my problem.

When the e-mail is sent, an exclamation point and a space are inserted in
about the 1907th position. The record I have been testing with, generates
2308 characters in CompleteBody. I get all of the characters, but get the
"! " inserted in the same position each time.

I have changed the line assigning Complete Body to objEmail.HTMLBody to
read:

objEmail.HTMLBody = "12345" & CompleteBody

Then the location of the "! " comes 5 characters sooner in the text, still
in the 1907th position.

I am baffled. If I were exceeding limitations, I would be losing characters
at the end of my e-mail. But I am not. I get all of the text, but have the
"! " inserted.

Any guidance you can provide will be greatly appreciated.

Leo Mansi
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top