VBA, Address format of Postal Address field when written into Word or Excel document

Address format of Postal Address field when written into Word or Excel document

Author	Message
rachel.edg #1 / 4	Address format of Postal Address field when written into Word or Excel document When I try to write a multi line Outlook field (such as Postal Address or Body) into a Word or Excel document little squares appear at the end of each line. I can easily delete these but can I prevent them appearing? Is there some sort of formatting command I can use? Thanks, Rachel Edge
Mon, 03 Mar 2003 03:00:00 GMT

rachel.edg #2 / 4	Address format of Postal Address field when written into Word or Excel document I've had another look at this problem for myself and found the answer! I was trying to write text into a text field in a Word document - doing this all the carriage returns are turned into boxes. I have found that you don't get this problem if you use a bookmark to mark a location in the Word document and then write text in at this point. I presume that you get a similar problem with Excel because you can't usually put formatting or carriage returns into an Excel cell. If you try to, you get the little boxes. Is there any way round this problem in Excel or should I try writing the text into a Word table instead? Thanks Rachel Quote: > When I try to write a multi line Outlook field (such as Postal Address or > Body) into a Word or Excel document little squares appear at the end of each > line. I can easily delete these but can I prevent them appearing? Is there > some sort of formatting command I can use? > Thanks, > Rachel Edge
Tue, 04 Mar 2003 03:00:00 GMT

Sue Mosher [MVP #3 / 4	Address format of Postal Address field when written into Word or Excel document For Excel, try adding a function to your code to strip all the Chr(13) characters before you push the text into the cell. -- Sue Mosher Author of "Teach Yourself Microsoft Outlook 2000 Programming in 24 Hours" "Microsoft Outlook 2000 E-mail and Fax Guide" Outlook and Exchange solutions at http://www.slipstick.com Quote: > I've had another look at this problem for myself and found the answer! I > was trying to write text into a text field in a Word document - doing this > all the carriage returns are turned into boxes. I have found that you don't > get this problem if you use a bookmark to mark a location in the Word > document and then write text in at this point. > I presume that you get a similar problem with Excel because you can't > usually put formatting or carriage returns into an Excel cell. If you try > to, you get the little boxes. Is there any way round this problem in Excel > or should I try writing the text into a Word table instead? > Thanks > Rachel > > When I try to write a multi line Outlook field (such as Postal Address or > > Body) into a Word or Excel document little squares appear at the end of > each > > line. I can easily delete these but can I prevent them appearing? Is > there > > some sort of formatting command I can use? > > Thanks, > > Rachel Edge
Tue, 04 Mar 2003 03:00:00 GMT

Page 1 of 1

[ 4 post ]