473,724 Members | 2,216 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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?
Nov 13 '05 #1
7 1860
In article <0i************ *************** *****@4ax.com>, MLH
<CR**@NorthStat e.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 ld@xyz.com

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)
Nov 13 '05 #2
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.

xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxx

How exactly have you typed in the name & email?

If I enter

Les D ld@xyz.com

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.


Nov 13 '05 #3
MLH
Well, it didn't help much. I get pretty much the routine thing. Its a
hyperlink (mailto:Na**@do main.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.


Nov 13 '05 #4
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.
Nov 13 '05 #5
In article <ss************ *************** *****@4ax.com>, MLH
<CR**@NorthStat e.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)
Nov 13 '05 #6
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.
Nov 13 '05 #7
In article <t6************ *************** *****@4ax.com>, MLH
<CR**@NorthStat e.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)
Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
2990
by: dave | last post by:
Hello, I'm creating a site that has several contact email addresses. These are vlid addresses, i'm wondering if i can use php to alter these addresses so that spam harvesters can't get them, yet a normal user clicking on them can? Thanks. Dave.
2
3333
by: Hoang | last post by:
anyone know of an algorithm to filter out real email addresses as opposed to computer generated email addresses? I have been going through past email archives in order to find friends email address. Unfortunately about 75% of them are junk addresses or spammer addresses. It's quite obvious when you look at it and delete it... but you don't want to do it by hand.
2
6753
by: Jim Fox | last post by:
Thought maybe I could do this with a hyperlink field in a table...........but doesn't seem to be working. I basically got a vendors table with all the contact info. One of the fields is EMAIL (for the email address of the contact). Basically I want people to be able to click on the email address or field and have their default mail program pop up with that address in it. How can I do this? Am I thinnk to hard about this and should...
2
6636
by: Doug | last post by:
I'm a little confused by this functionality. It doesn't seem to be behaving like it should. I am using the following regular expression to validate email addresses: "\w+(\w+)*@\w+(\w+)*\.({2,4})\040*". From what I can determine it should validate the following rules: 1. BEFORE THE AMPERSAND A. Must contain at least one alphanumeric character.
23
2872
by: codefire | last post by:
Hi, I am trying to get a regexp to validate email addresses but can't get it quite right. The problem is I can't quite find the regexp to deal with ignoring the case james..kirk@fred.com, which is not valid. Here's my attempt, neither of my regexps work quite how I want: import os import re
3
2875
by: g0c | last post by:
hi, how to hide or replace email addresses in php mail function with something like "group" so the email addresses to which email is sent are not visible ? i have : $subs = "email1@dot.com, emai2@dot.com, email3@dot.com" $header .= "To : email@notset.com\r\n";
12
1337
by: Adrian | last post by:
Is there a way to know which email addresses viewed my website? Thanks, Adrian.
45
4439
by: Dennis | last post by:
Hi, I have a text file that contents a list of email addresses like this: "foo@yahoo.com" "tom@hotmail.com" "jerry@gmail.com" "tommy@apple.com" I like to
21
14827
by: farisallil | last post by:
Hi I have a table called Info with a column called Email Address in it. I want to create a command button in a form called Customer ,which has the Info table as the Record Source, and I want this command to open up a new email window in Outlook 2007 and copy all the email addresses to the To field without forgetting adding a semicolon after each email How can I do that? or what is the VB code for such button? I'm not so good in Access but I...
0
8868
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8741
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9389
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9160
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9090
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6689
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5996
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4771
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2613
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.