|
e-News Letter
Keep
in Touch with Your Customers and Club Members
To Place an Order Create
a New Account or
Log-in
Only
$.05 per email + $50.00 Setup Fee. (volume discounts available)
*
For your convenience the Customers database is used for the
e-Birthday
Letter
as
well as for the e-News Letter. You only
maintain
one central database.
The
EHC
Communications e-News
Letter service is a cost effective way to
maintain
your customers informed of your special promotions, daily, activities,
calendar
and
in
general,
what is
happening at your
hotel
or company.
The
e-News Letter
is broadcasted via email. You can
schedule the email
broadcast
at your convenience, just tell us the date and time.
You can
include
in
your
news
letter
logos, images, hyper links to your own site
pages or email links at no cost.
You can
send your news
letter
material to us in the following document formats,
MS Word, MS Excel, MS Power Point,
htm
or just plain text.
We
can
convert your news letter material to
email/html format.
You
can send us your customer profiles in MS Excel, DBase or MS
Access. We
will import them at no cost as well as you can maintain
your contact list on-line.
The
e-News Letter can be personalized with
your client record information.
Instructions
Log-In
with the user-id and password you specified. This will redirect you
to the management menu where you can
maintain your account and
order any of the services.
Once
you are in the Management Menu, select the e-News Letter option
to display the e-News Letter sub menu.
In
the e-News Letter Sub-Menu, select
Customers Database Setup. Only the first
time.
In
the e-News Letter Sub-Menu, select Send
Customers Database, to send us your customers
database or updates. This can be done
as many times you need. You can send us the customers
database in MS Excel, MS Access, Dbase, comma delimiter or fix
length fields.
Select
Maintain Customers Database, to
maintain your customers database on-line.
(add/delete/modify/inactivate)
Select
the Send e-News Letter material, to send us your news
letter by email. You can send us your
news letter in MS Word, MS Excel, MS Power Point, plain text
or in HTML format.
The
last step is to enter the Broadcast Selection. In this
step is where you select your target customers by
contact type and/or country as well as the date and time of the
e-New Letter broadcast.
Downloads
In order to
facilitate to you the upload of your
customer records you can download from here a blank
database with the customer record pre-defined. You
can also create your own format (see record format below).
MS
Excel 2000 Customer
Record Format
MS
Access 2000
Customer
Record Format
Dbase
III Customer
Record Format
Accepted
Formats for Contacts Import
|
Data Source
|
Version or
Format Supported
|
| Microsoft
Access database |
2.0,
7.0/95, 8.0/97, 9.0/2000 |
| Microsoft
Access project |
9.0/2000 |
| dBASE |
III,
III+, IV, and 5 |
| Paradox,
Paradox for Windows |
3.x,
4.x, and 5.0 |
| Microsoft
Excel spreadsheets |
3.0,
4.0, 5.0, 7.0/95, 8.0/97, and 9.0/2000 |
| Lotus
1-2-3 spreadsheets |
.wks,
.wk1, .wk3, and .wk4 |
| Microsoft
Exchange |
All
versions |
| Delimited
text files |
All
character sets |
| Fixed-width
text files |
All
character sets |
Contact
Records - File Format
| Description |
Field Name |
Type |
Len |
Merge
Char. |
Examples |
| Account Number |
ehc_acct |
Numeric |
15 |
*AC |
Your E-HospitalityCentral
Account Number. |
| Contact ID |
contact_id |
Text |
15 |
*CI |
Your Customer ID.
Used by e-HospitalityCentral to identify your contact record. |
| Company Name |
company_na |
Text |
30 |
*CN |
|
| Title |
title |
Text |
30 |
*TI |
President, General
Mgr. |
| Salutation |
salutation |
Text |
10 |
*SA |
Mr. Ms. Engineer
Judge Professor |
| First Name |
first_name |
Text |
20 |
*FN |
|
| Last Name |
last_name |
Text |
20 |
*LN |
|
| Address Line 1 |
address_1 |
Text |
30 |
*A1 |
|
| Address Line 2 |
address_2 |
Text |
30 |
*A2 |
|
| City |
city |
Text |
30 |
*CI |
|
| State |
state |
Text |
2 |
*ST |
|
| Zip Code |
zip_code |
Text |
15 |
*ZC |
|
| Country Code |
coutry_co |
Text |
2 |
*CC |
Based
on ISO 2 Letter Codes |
| Tel. Country Code |
tel_ctry_c |
Text |
6 |
*TC |
|
| Tel. Area Code |
tel_area_c |
Text |
6 |
*TA |
|
| Tel. Number |
tel_number |
Text |
10 |
*TN |
|
| Fax Country Code |
fax_ctry_c |
Text |
6 |
*FC |
|
| Fax Area Code |
fax_area_c |
Text |
6 |
*FA |
|
| Fax Number |
fax_number |
Text |
10 |
*FN |
|
| Birth Date |
birth_date |
Date or Text |
8 |
*BD |
Example: 10/25/57 |
| Email |
email |
Text |
60 |
*EM |
|
| Contact Type 1 |
contact_t1 |
Text |
10 |
*T1 |
User can define
usage of this field. Used as part of the selection criteria
when sending the e-News Letter. |
| Contact Type 2 |
Contact_t2 |
Text |
10 |
*T2 |
User can define
usage of this field. Used as part of the selection criteria
when sending the e-News Letter. |
| Contact Type 3 |
Contact_t3 |
Text |
10 |
*T3 |
User can define
usage of this field. Used as part of the selection criteria
when sending the e-News Letter. |
| Language |
language |
Text |
3 |
*LA |
User can define
usage of this field.
Examples:
ENG=English or
1=English or
E=English |
| Member ID |
member_id |
Text |
15 |
*MI |
User can define
usage of this field |
| Geographic Area |
geo_area |
Text |
1 |
*GA |
Example:
1 The Americas
2 Europe, Middle East and Africa
3 Asia, Australia and Oceania
* User can define their own
Geographic Areas |
| Contact Record Status |
rec_status |
Text |
1 |
*CS |
(A)ctive (I)native (D)elete
If status not specified (A)ctive status will be considered. |
*
Notes: All fields are optional except for Contact ID.
Merge fields are substituted with information from the
customer record.
|
|
|
