vbCrLf displays as ? in formfields

[Paul Isaak]

I'm trying to populate a series of formfields in a word doc with info
obtained programmatically from outlook.

my problem is that if the outlook field contains a linefeed character or a
carriage return (among others), the formfield in word displays it as ??
instead of inserting a Linefeed.

so an address displays as...

123 anystreet ?? Las Vegas, NV ?? USA

instead of

123 anystreet
Las Vegas, NV
USA


here's the code in question

contractdoc.documentscontractdocid).formfields"Customer_Address").result=Application.ActiveExplorer.Selection(1).BusinessAddress

All thoughts appreciated.

Paul



--
__________________________________

The Comedy & Juggling of Paul Isaak
http://www.funnyjuggler.com



Toll Free - 1-877-852-4590

 

[Paul Isaak]

my problem is that if the outlook field contains a linefeed character or a
carriage return (among others), the formfield in word displays it as ??
instead of inserting a Linefeed.

when I posted this msg, outlook has changed the "square box" I typed into
"question marks". replace the question marks above with unicode 25a1 to
understand my original question (which brings about another question - how
do I type a msg with unicode chr 25a1, without if changing in the news
server)

 

[Doug Robbins - Word MVP]

The Outlook Contacts folder contains the following fields in addition to the
Business_Address field

Business_Address_Street
Business_Address_City
Business_Address_State
Business_Address_Postal_Code
Business_Address_Country

You should get the data from the individual fields rather than from the
Business_Address field that arranges the individual fields

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi Paul,

I'm trying to populate a series of formfields in a word doc with info
obtained programmatically from outlook.

my problem is that if the outlook field contains a linefeed character or a
carriage return (among others), the formfield in word displays it as ??
instead of inserting a Linefeed.

the form fields are in a Word table, I'm guessing? And there's no paragraph
mark (¶) preceding the end-of-cellmarker?

This is a known bug in Word. Press ENTER at the end of the cell and the
problem should go away. (If this makes the cell "too tall", set an exact row
height)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail