|
e-Birthday
Letter
Everybody loves to
be remembered in their birthday
Just
the fact that you remember
means a lot to your customers
To
Place an Order Create
a New Account or
Log-in
Only
$.05 per email + $50.00 Setup Fee.
Billed Monthly based on e-Birthday Letters sent.
* 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
e-Birthday
Letter is
broadcasted via email, in the customer birth day.
You can
include
in
your
e-Birthday Letter
logos, images, hyper links to your own site
pages or email links at no cost.
You can
send your e-Birthday
Letter
material to us in the following document formats,
MS Word, MS Excel, MS Power Point, Html format or just plain text.
At
no cost we will convert your news letter material to
email 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-Birthday
Letter can be personalized with
your client record information.
Instructions
services.
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-Birthday Letter option
to display the e-Birthday 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-Birthday 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. Only one time or when changing the
e-Birthday Letter format.
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.
|
|
|
