Colour & data formatting in Outlook from Visual Basic

[Jyo72]

Hi,

I need help to solve my problem. I am a newbie in VBA -- outlook.
I have to create a module to create outlook body text with data, editable text boxes and need to pass some text wiht different colours based on status(for example-- tentative....blue, rejected in red etc....)

I am able to pass a simple text and a line to outlook message body. But unable to send a textbox and formatted coloured text.

Your help is much appreciated & Thanks in advance.

[Dököll]

Hi,

I need help to solve my problem. I am a newbie in VBA -- outlook.
I have to create a module to create outlook body text with data, editable text boxes and need to pass some text wiht different colours based on status(for example-- tentative....blue, rejected in red etc....)

I am able to pass a simple text and a line to outlook message body. But unable to send a textbox and formatted coloured text.

Your help is much appreciated & Thanks in advance.

Hello Jyo72!

I have not yet worked with outlook through VBA or VB. Perhaps VBA forum may have a way to achieve, not sure how it can be handled in VB.

I did some snooing around and found below, hope you did not see them as of yet:

http://www.outlookcode.com/article.aspx?id=20

I think something better than my find may be available if you search above site. If that does not work, please fetch my Google results:

http://www.google.com/search?q=Colou...e7&rlz=1I7SUNA

You probably already searched Google, I pretty much copied your titlw anf fired away;-) Hope there's something there, if not, do stay stuned in VBA, just in case an idea is there.

Good luck with the project, also, please do come back here in VB is what you needed, I could have missed that.

In a bit Jyo72:-)

Dököll

[Jyo72]

Thanks for the reply Dokoll.
I did lot of search on google and many sites & forums. But no luck.
Not much to do this from VB to Outlook.

Appreicated your search and guidance.
Thanks again.

Hello Jyo72!

I have not yet worked with outlook through VBA or VB. Perhaps VBA forum may have a way to achieve, not sure how it can be handled in VB.

I did some snooing around and found below, hope you did not see them as of yet:

http://www.outlookcode.com/article.aspx?id=20

I think something better than my find may be available if you search above site. If that does not work, please fetch my Google results:

http://www.google.com/search?q=Colou...e7&rlz=1I7SUNA

You probably already searched Google, I pretty much copied your titlw anf fired away;-) Hope there's something there, if not, do stay stuned in VBA, just in case an idea is there.

Good luck with the project, also, please do come back here in VB is what you needed, I could have missed that.

In a bit Jyo72:-)

Dököll

[missinglinq]

Are you trying to do this using an MS Access database? I ask this because you post makes no mention of a database, and the forum title, Access/VBA is sometimes misleading. The VBA part refers to VBA used in Access, not VBA used in other Microsoft apps, such as Word, Excel or Outlook.

Linq ;0)>