Item 19 - Email Merge
32bit Email Broadcaster supports mail merge into the subject and message
body, with up to 10 fields plus the email address, Day, Date, Time, and
Time Stamp. The merge fields can be stored in comma delimited format. You
do not need to use comma delimited format if you just want to merge the
recipient's name and/or the email address.
Here is a sum-up of the rules for the Email Address File:
The five supported Email Address methods:
Email Address only, method 1:
Ename@Domain.com
Email Address and Name, method 2:
Ename@Domain.com (Name)
Name and Email Address, method 3:
Name <Ename@Domain.com>
Name in double quotes and Email Address, method 4:
"Name" <Ename@Domain.com>
Email Address and [Merge Fields 1 through 10], method 5:
"Ename@Domain.com","Merge Field 1","2","3","4","5","6","7","8","9","10"
Method 1 is when you have one email address per line.
Method 2 is when you have the email address on the line first and then the
recipient's name in parenthesis after the email address. A space is needed
in between the two.
Method 3 is when you have the recipient's name at the beginning of the
line and the the email address, enclosed in triangle brackets, after the
name.
Method 4 is the same as method 3 except the recipient's name is enclosed
in double quotes.
Method 5 is the comma delimited method which was mention above. Each field
has to be enclosed in double quotes and separated from the neighboring
field(s) by a comma. There can be up to 10 merge fields. If you have under
10 fields filled in, you do not need to have blank fields in place of no
information. You can use this method 2 different ways:
1st way:
Fully comma delimited:
"Ename@Domain.com","Merge Field 1","2","3","4","5","6","7","8","9","10"
2nd way:
Method 1 - 4 and then the 10 merge fields, ie:
"Ename@Domain.com","Merge Field 1","2","3","4","5","6","7","8","9","10"
or
"Bill <Ename@Domn.com>","Merge 1","2","3","4","5","6","7","8","9","10"
or
"Ename@Domn.com (Bill K)","Merge 1","2","3","4","5","6","7","8","9","10"
Merge field 1 is actually the 2nd field, but the 1st field is reserved for
the email address. Merge field 1 and on can be used for whatever
information you would like to have. A field in one line should have the
same type of information as another comma delimited line does. For
example, if on one line, the 1st merge field has the recipients name in
it, you would want all other comma delimited lines to have the recipient's
name in the 1st merge field.
example:
"support@domain.com","Jon Krahmer","Tech Support"
"eaddress@domain.com","John Doe"
All 5 of these email address methods can be used in the same Email Address
File. However, if you call a mail merge field in the email message that
does not exist in one or more of the lines in the email address file,
nothing will be inserted in the email message where the merge was
attempted.
- Rules for using methods 1 through 4:
- The Email Address field can be no longer than 128 characters.
- Rules for using the [Merge Fields 1 through 10], method 5:
- Email Address can be no longer than 128 characters.
- Merge Fields can be no longer than 128 characters.
- The total line can not be longer than 1440 characters. We derive at this
number by multiplying 128 characters per field times a total of 11 fields
which is 1408, plus 32 characters for the double quotes and commas
equals 1440 characters.
The following is a list of the email merge fields you can use:
(Below this list is an explanation on how to use them)
============+===============+=============================================
Merge Code: | Merge Field: | More Information:
============+===============+=============================================
[%$%FN] | First Name |
------------+---------------+---------------------------------------------
[%$%FNorEA] | First Name or | use Email Address if no Name is included
------------+---------------+---------------------------------------------
[%$%LN] | Last Name |
------------+---------------+---------------------------------------------
[%$%LNorEA] | Last Name or | use Email Address if no Name is included
------------+---------------+---------------------------------------------
[%$%WN] | Whole Name |
------------+---------------+---------------------------------------------
[%$%WNorEA] | Whole Name or | use Email Address if no Name is included
------------+---------------+---------------------------------------------
[%$%EA] | Email Address |
------------+---------------+---------------------------------------------
[%$%DY] | Day | Current Day, ie: Fri
------------+---------------+---------------------------------------------
[%$%DT] | Date | Current Date, ie: 15 Sep 2000
------------+---------------+---------------------------------------------
[%$%TM] | Time | Current Time, ie: 12:20:28
------------+---------------+---------------------------------------------
[%$%TS] | Time Stamp | Time Stamp, ie: Fri, 15 Sep 2000 12:20:28
------------+---------------+---------------------------------------------
[%$%MF1] | Merge Field 1 | 1 through 10 [%$%MF1], [%$%MF2],...[%$%MF10]
============+===============+=============================================
To use merge fields in the Email Message File or Subject, you paste in the
merge code where you want it to be. For example:
If this was an entry in the Email Address File:
"support@domain.com","Jon Krahmer","ElectraSoft"
and the following is the email message text:
Hello [%$%MF1] of [%$%MF2], How are you?
It would send this:
Hello Jon Krahmer of ElectraSoft, How are you?
You can also insert just the first name or just the last name. Look in the
above table to view merge codes for various items. The name merge codes
will not work in a comma delimited entry. You would use the merge field
code [%$%MFx], where x is a number between 1 and 10. See bottom of above
table.
Also, there are merge codes such as time, date, and email address you can
insert. Refer to the above table for the merge codes for these.
How to export your own information to a comma delimited file using
MS Access:
- In MS Access:
- Open the database file.
- Select the [tables] tab.
- Highlight the table that you want to export to our software.
Note: Before exporting, be sure that the fields are set up correctly:
Make sure that the email address field is the first field.
Make sure that there are no more than 11 columns/fields.
You will need to convert all field's data types to text if they
are not yet defined as text. To do this, look at the table in
Design View. Change each field's [Data Type] to text.
- Click on [File], [Export...].
- At the bottom, be sure the [Save as Type:] is set to
[Text Files(*.txt; *.csv;... etc)].
- Browse to the folder where you have 32bit Email Broadcaster installed.
- Click on [Save].
- Check the [Delimited - Characters such as...] CheckBox if it is not
checked, then click [Next].
- Where it says, [Choose the delimiter that separates your fields], choose
[Comma].
- Uncheck the [Include Field names on first row] if it is checked.
- Make sure the [Text Qualifier] is set to ["], and click on [Next].
- Click on Finish.
The file has now been exported to a comma delimited file. Now you can
use this file as the [Email Address File] in 32bit Email Broadcaster and
take advantage of Email Merge if you choose to. If you followed the above
directions to the key, then the file you exported should be in the same
folder 32bit Email Broadcaster is installed in and should show up when you
browse for the [Email Address File] with 32bit Email Broadcaster.
If you want to export a data file from a program other than MS Access and
you do not know how, please contact the software vender and ask for help
on how to set up instructions that will allow you to export your data to a
comma delimited file with each field surrounded with double quotes.
-Back to the Top-