Setting Paragraphs in Access generated email

S

SnooziSuzi

Hello,

I am sure I have read the answer to my question somewhere in the Access
forum somewhere, but I can't find it so need to ask this again.

In short, an email with an attachment is generated from a database which I
have inherited but the text within the email is unformatted and in one long
line.

Firstly: I'd like to seperate the different paragraphs
Secondly (and not so important so OK if this can't be done): I'd like to
format the text (colour / font / size) to highlight certain words.

Just to add to this; I've inherited this database and am not 100% familiar
with it therefore any coding you suggest could you please talk me through it
as if I'm 5!

Is this possible?

Thanks in advance
 
M

mscertified

Insert VBCRLF characters in your message.
Find where the message is composed and use the following technique:
e.g.
msg="This is one line" & vbcrlf & "this is another"

I dont know how to change the font or color of parts of the text, I'l leave
that for someone else.

-Dorian
 
Top