Message body and Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Thanks Sue

Sue Mosher said:
Yes, it's necessary to use Replace().

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
Click to expand...
 
Back
Top