ive done a few very long text strings for use in emails, and yes you are
correct readibility when constructing these string has proven to be a
bit of a contest. i found that if i grouped it in sections (like Company
headers, References numbers, return sender ect) this way it made it a
little easer to edit it. though doing it like you have is quite easy to
read.

the part of the code that you have pointed the
.body is the part of the email that will make
up the text part.

so you can assign it as many variables as you like. so to join the
variables (strings)
Code:
--------------------
.Body = strbody1 & srtBody & "keep joing stuff here"
--------------------
its just like you have done in the building of the streBody variable.

also just noted on your code that you have referenced a workbook.
destWb
though this variable has not been set and you go on to fully qualifiy
the code. there is no point in having the with destWb and end with (its
just aboue and below what you last posted)

good luck, if have have any other troubles, please post a workbook and
ill take a look at it. (rember to remove any senctive information but
leaving enough (or inserting fake information) to complie the message
string.

cheers


--
D_Rennie
------------------------------------------------------------------------
D_Rennie's Profile: 1412
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=172454

Microsoft Office Help