Message body and Excel

[Guest]

I'm planning to use Excel to report the contents of a public folder as
outlined in Sue's book. To begin with, as an experiment, I tried just pasting
the contents of the folder into Excel, but the message body (which is a key
part of the report) splits itself up at each carriage return so that a single
item can cover several rows (i.e. as many rows as there are return characters
plus one).

I suppose when I get to automate the process I can use replace() to get rid
of the return characters, but is it necessary? Is there a simple way of
dealing with this issue that I'm missing?

Thanks

Vaughan

 

[Sue Mosher [MVP-Outlook]]

Yes, it's necessary to use Replace().

 

[Guest]

Thanks Sue

Yes, it's necessary to use Replace().

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers