VBA - ".body" assistance - please?!

PJMcK

New member
Local time
Today, 19:41
Joined
Mar 1, 2005
Messages
4
Hi,
I've been looking for a way to set formatting for the .body property of an Outlook2000 task that I create from a form in MSAccess2000.

I am using the format .body = "text" & [Me!fieldname] & "moretext" & [Me!morefields], for the task subject, etc - and all works fine.

The problem is that I need to be able to insert a new line between some of the referenced fields, and maybe even some font formatting for different fields in the ".body".

..so that the body of my text has a defined layout (e.g. A text heading, with access field value underneath it), and not all one string of concatenated crap! :(

Thanks in anticipation... :o
 
Code:
MyText & vbCrLf & MoreText
 
Thank you so much! That's a great help. :D
It's opened up a whole new world of fun (I may try to use [tabs] as well as CrLf.

Does anybody have a suggestion for my "text formatting" issue?
 

Users who are viewing this thread

Back
Top Bottom