Formatting Body of Meeting Request

S

Steve

I have a function in an Access 2003 module to create a meeting request and
send it out. This function is called by a sub procedure in a form module and
the necessary variables are passed to the function. Code works fine other
than the body of the meeting request is not doing carriage returns like it
should. The text is formatted correctly by the sub procedure that calls the
function (I displayed it with a msgbox to confirm it was correct there), but
it loses the format in the meeting request. I am guessing that the meeting
body is in html format, but that is a guess. I want to have two carriage
returns between each section of text so there is an empty line between each
piece of text.

Any suggestions to get the meeting body formatted like this?

Steve
 
M

Michael Bauer [MVP - Outlook]

The body format of the AppontmentItem is RTF. To add a carriage return you
can use the constant vbCRLF.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Fri, 9 Jan 2009 17:30:01 -0800 schrieb Steve:
 
S

Steve

That worked. I have vbCR & vbCrLf, but I changed them both to vbCrLf and it
came through on the meeting body as I wanted. Just seems odd that the msgbox
in Access showed the carriage return just fine with vbCr & vbCrLf but it
didn't work in the meeting request. But it's all good now. Thanks.
 

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