A97 - How to preserve eMail addresses pasting contact info from MS Word doc to A97?

[MLH]

I have a several hundred contact info entries in an MS Word document
(name / addr / phone / email / website) - the usual sort of thing.

I want to put the data into an A97 table. In my Word document, a URL
typed in shows up as a hyperlink. Cutting & pasting preserves the URL
because they're typed in literally. On the other hand, the eMail addrs
show up as the person's name (John Doe) and an eMail type hyperlink
is in place behind the scenes so-to-speak. But cutting and pasting
the eMail token preserves the token only - IE, "John Doe" instead
of JK***@EarthLink.net.

So, I'm at a loss as to how to get it into Access w/o manually
extracting each and every one of the addresses - whew! Any
suggestions?

[Les Desser]

In article <0i********************************@4ax.com>, MLH
<CR**@NorthState.net> Fri, 2 Sep 2005 11:05:38 writes

I have a several hundred contact info entries in an MS Word document
(name / addr / phone / email / website) - the usual sort of thing.

I want to put the data into an A97 table. In my Word document, a URL
typed in shows up as a hyperlink. Cutting & pasting preserves the URL
because they're typed in literally. On the other hand, the eMail addrs
show up as the person's name (John Doe) and an eMail type hyperlink
is in place behind the scenes so-to-speak. But cutting and pasting
the eMail token preserves the token only - IE, "John Doe" instead
of JK***@EarthLink.net.
How exactly have you typed in the name & email?

If I enter

Les D [e-mail]

into Word (97) the Les D stays and the next bit turns into a link.
So, I'm at a loss as to how to get it into Access w/o manually
extracting each and every one of the addresses - whew! Any
suggestions?

Try save-as into .txt or export into Excel and see what happens.
--
Les Desser
(The Reply-to address IS valid)

[MLH]

I copied 'n pasted them into MS Word from
http://www.nahb.org/local_associatio....aspx?state=CA
Just copied the tabular data on that page.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

How exactly have you typed in the name & email?

If I enter

Les D [e-mail]

into Word (97) the Les D stays and the next bit turns into a link.

So, I'm at a loss as to how to get it into Access w/o manually
extracting each and every one of the addresses - whew! Any
suggestions?

Try save-as into .txt or export into Excel and see what happens.

[MLH]

Well, it didn't help much. I get pretty much the routine thing. Its a
hyperlink (mailto:Na**@domain.com) That's what I see in MS
Word, pointing at and hovering over the link. Still no automated
way of extracting the underlying eMail address from the stuff. I
suppose I could search the HTML for mailto: strings. I was just
hoping for a simpler solution.

Try save-as into .txt or export into Excel and see what happens.

[MLH]

Dunno why, but pasting the stuff into WordPad SHOWS the actual
eMail addresses enclosed in < > after the token name. That'll work 4
me. I can suck it all into a table easily enough. Thx Les.

[Les Desser]

In article <ss********************************@4ax.com>, MLH
<CR**@NorthState.net> Fri, 2 Sep 2005 14:54:25 writes

Dunno why, but pasting the stuff into WordPad SHOWS the actual
eMail addresses enclosed in < > after the token name. That'll work 4
me. I can suck it all into a table easily enough. Thx Les.

Pleased you get there somehow.
--
Les Desser
(The Reply-to address IS valid)

[MLH]

Yeah, me too. Thanks a lot, Les.

I'm working with lots of long strings now, it seems.
I have to import them & parse them constantly. The
A97 memo field type supports only 32768 chars.
What about Dim MyString As String - how big can
a string be that I wanna assign to MyString?

I have done some homework, but I don't understand
my findings. Here's what I read in HELP...

There are two kinds of strings: variable-length and fixed-length
strings.

· A variable-length string can contain up to approximately 2
billion (2^31) characters.
· A fixed-length string can contain 1 to approximately 64K
(2^16) characters.

But it is not at all clear to me how to declare a variable-length
string VS a fixed-length string. Do you know? I think I'll start
a thread dedicated to this Q.

[Les Desser]

In article <t6********************************@4ax.com>, MLH
<CR**@NorthState.net> Tue, 6 Sep 2005 10:23:09 writes

I'm working with lots of long strings now, it seems.
I have to import them & parse them constantly. The
A97 memo field type supports only 32768 chars.
From Help: A Memo field can store up to 64,000 characters

A memo field is defined in a database. I don't think you can declare it
in VB.
What about Dim MyString As String - how big can
a string be that I wanna assign to MyString?
Again from Help:

String (variable-length) 0 to approximately 2 billion

String (fixed-length) 1 to approximately 65,400
I have done some homework, but I don't understand
my findings. Here's what I read in HELP...

There are two kinds of strings: variable-length and fixed-length
strings.

· A variable-length string can contain up to approximately 2
billion (2^31) characters.
· A fixed-length string can contain 1 to approximately 64K
(2^16) characters.
So we agree :)
But it is not at all clear to me how to declare a variable-length
string VS a fixed-length string. Do you know? I think I'll start
a thread dedicated to this Q.

Just doing a Dim xx as String defines a variable length string.

I forget the syntax of a fixed length string but it is not the default
type.
--
Les Desser
(The Reply-to address IS valid)