| |
VEDIT includes several ready-to-run macros that can really help when
working with e-mail addresses.
| E-EMAIL.VDM |
Extract all "From:" and "Reply-to:" e-mail addresses from
an e-mail archive file, sort them and remove duplicates.
Works well with Eudora .MBX files. |
| E-XTRACT.VDM |
Extract all e-mail addresses from a data or log file, sort
them and remove duplicates. |
| EXTRACT.VDM |
Extract all records (lines) from a file which contain a
specified search string. You can even automatically
extract records (lines) from entire groups of files. For
example, you could extract all "@aol.com" addresses.
This macro also has many database uses and is available
from the menu function {MISC, More macros, Extract}. |
| REM-LINE.VDM |
Remove all lines in a file which contain a string listed in a file of
"remove strings". Works well for comparing two lists of items
(e.g. email addresses) - creates a file of the different items and a file
of the common items. The next example uses this flexible macro. |
Consider this task:
You want an e-mail list of prospective customers that have inquired
about a product. Their e-mail addresses are in Eudora (tm). However,
you must exclude customers that have already purchased the product.
Customer e-mail addresses are in MS Access (tm).
Here is an overview of the steps needed to perform this task.
- Inside Eudora, create a temporary mail folder, e.g "Prospects".
Copy all prospective customer email messages to "Prospects".
(You can copy by holding down the <Shift> key while dragging.)
- From VEDIT, run the E-EMAIL.VDM macro. At the prompt for the
filename, enter the full pathname to the file "prospects.mbx" in the
Eudora folder.
At the prompt for the destination filename, enter e.g. "prospects.txt".
The macro will extract all the email address, remove duplicates,
sort them, and save them in prospects.txt.
- From MS Access, export the table containing the customer email
addresses. Export only the email address field. Save the email
addresses in a file, e.g. "customer.txt".
If you have trouble exporting only the email addresses, use the
VEDIT macro E-XTRACT.VDM to extract the email addresses from the
export file.
- From VEDIT, run the supplied REM-LINE.VDM macro.
For the source filename, enter the pathname to "prospects.txt".
For the remove list filename, enter "customer.txt".
For the destination filename, enter e.g. "mailing.txt".
For the matching filename, enter e.g. "match.txt".
The macro will remove from prospects.txt any email addresses
which are also in customer.txt. It saves the resulting file
as mailing.txt. The file match.txt will contain the email addresses of
(recent) customers that are on the prospects list.
In other words: mailing.txt + match.txt = prospects.txt
When completed, you will have a list of email addresses in the file
"mailing.txt" which consists of everyone that has inquired about a
product, but hasn't purchased it.
(You can then use the mail merge capabilities in MS Word to send
a follow-up letter, special offer, etc. to your prospects.)
Please contact us with any sales or technical questions at:
| Mailing address: |
Greenview Data, Inc. PO Box 1586, Ann Arbor, MI 48106 USA |
| Phone (Sales): |
In US and Canada call Toll-Free 1-800-458-3348 |
| Phone: |
Otherwise, please call (734) 996-1300 |
| Fax: |
(734) 996-1308 |
| E-mail: |
sales@vedit.com or
support@vedit.com |
Top of Page |
VEDIT text editor (Home) |
Anti-spam service |
Contact |
Privacy
Copyright © 1998-2004 Greenview Data, Inc. All rights reserved.
|
