MrExcel Publishing
Your One Stop for Excel Tips & Solutions

e-mail


Posted by Qroozn on January 14, 2002 2:52 PM

in .message in my router i have got a message but instead of the message being continuous i want it to start on a new line a=t the end of each sentence. is there something like vbleft i can use
eg.

.message"thsa;l dsaof;adsc dschds dsvsdv asdvkaskdv sfdvafsv avkiafv"

to read in the email as

thsa;l dsaof;
adsc dschds
dsvsdv asdvkaskdv
sfdvafsv avkiafv

TIA


Posted by Nate Oliver on January 14, 2002 3:13 PM

I've implimented this in Lotus notes try this:

.message range("a1")

In range a1, place hard returns by pressing alt-enter.

If you want spaces in between, press alt-enter, spacebar, alt-enter.

Good luck, and Cheers!

Nate

Posted by Qroozn on January 14, 2002 3:22 PM

Nate... You Legend

Nate
you legend!

Thanks.

Posted by Nate Oliver on January 14, 2002 3:23 PM

You're Welcome

Appreciate the feedback.

Cheers! Nate