Email Generator UtilityBy selecting up to 65,536¹ email addresses from within any spreadsheet, you can:
- Instantly create mass distribution direct email files for use with Microsoft® Outlook Express or any other email client program.
- Export these email addresses to Comma Separated list files which can later be imported into your email client’s address book.
- Business: Generate mass distribution direct emails for both current and potentially new customers.
- Members and Groups: Email group members about news and activities.
- Includes full detailed instruction with illustrations.
Note: All the information within this document is also available within the utility itself. Refer to the Help section of the program.
Email Generator Description
This Email Generator utility is a powerful tool. By selecting up to 65,536¹ email addresses from any spreadsheet, you can instantly create fully functional mass distribution direct email letters for use with either Microsoft® Outlook Express or any other email client program. It can also be used to create Comma Separated email address list files for later importing into your email client’s address book.
The image below is a screen shot of a sample file created by the Email Generator Utility and opened Microsoft® Outlook Express. It is addressed to 44 recipients. By using this utility, you can automatically create this type of email letter addressed up 65,536¹ recipients.
Instructions on using of the Email Generator Utility
To launch the Email Generator utility, click on the "Email Generator" menu item from Excel's Tools menu.
You will then be presented with the Email Generator Utility dialog box as shown below.
Step 1: What would you like to do ?
Select option 1 to generate a Microsoft® Outlook Express email letter file or option 2 to generate a Comma Separated email address list text file.
If you are not using Microsoft® Outlook Express as your email client program, but are using a different email client program, then choose the second option. This utility will then generate an ASCII text file containing the all email addresses in comma separated format. For example, address1, address2, address3, etc… This format is similar to Excel's comma separated values (CSV) format. You can then open the generated file any text editor such as Window's Notepad and cut & paste the email address list into your email letter's To:, CC:, or BCC: address locations.
This second option is also useful for exporting the email addresses to Comma Separated list files which can later be imported into your email client's address book.
Step 2: Select contiguous range of email address cells from any spreadsheet
Cell Selection: You will be prompted to select a contiguous range of cells. You can select cells from any spreadsheet, from within either the current workbook or any other workbook. The selection can also be within a column or within a row.
Caution: Depending on the power of your computer, the more email addresses you put into the email letter, the longer it may take to open your email client program.
Check this box to have the exported email addresses sorted in alphabetical order. You should also check this box if the selected range of cells may possibly contain blank cells. This sorting will not affect your original data.
Compose the Microsoft® Outlook Express Email Letter
If you selected to generate a Microsoft® Outlook Express email letter file, you will be presented with a dialog box to compose your letter. Only the checked boxes will be exported.
First, enter your email address in the To: location. By placing your email address here, you can verify that the email was sent properly because you will also receive a copy of the letter.
Select the address location to where you want to place the email addresses:
For effective personalized emailing, it is best to put the list of email addresses into the Bcc: address location. It is not necessary to use the Cc: address location unless you want everyone who receives the email to see the email addresses of the other people who were mailed the same letter. If you select the Bcc: option, the To: email address will not be displayed to the recipients of the letter.
Subject Line, Message Body, and Signature locations:
At this time, you can enter a maximum of 254 characters each for both the Subject Line and Message Body. After the email letter file is generated, you can open it in Microsoft® Outlook Express to edit the text if needed.
Saving the Generated File
At the end of the file generation routine you will be prompted to choose both a directory location and a file name. For the Microsoft® Outlook Express option, the file format is filename.eml. For the Comma Separated ASCII text file option, the file format is filename.txt.
Use the Quick Jump feature to immediately transfer you to the displayed directory path that you use most often. To set the Quick Jump directory path, either type in or cut & paste a directory path into the path edit box, and then press the “Save Path” button.
Emailing the Generated Files
Microsoft® Outlook Express Email Files
To open and email the multi-addressed email letter file in Microsoft® Outlook Express (filename.eml), go to the location where the file was saved and simply double click on it. You can then press Outlook Express’s Send button if you want to immediately send it without further editing.
The image below is a screen shot of a sample file created by the Email Generator Utility and opened Microsoft® Outlook Express. It is addressed to 44 recipients. By using this utility, you can automatically create this type of email letter addressed up 65,536¹ recipients. You also may notice that the text shown in the sample email is the default text shown in the ”Compose an Email Letter” dialog box image above.
Note: It may take some time, possibly a few minutes, to open the email files in Microsoft® Outlook Express if the email address lists contain over 1,000 email addresses. Be patience! Once a file is opened, you can further edit it if needed, or it can be sent immediately.
Comma Separated Email Address ASCII Text List Files
To open the email address ASCII text file (filename.txt) in your text editor, go to the location where the file was saved and simply double click on it. If you are using a different email client program other than Microsoft® Outlook Express, just cut & paste the comma separated email address list into your email letter's To:, CC:, or BCC: address locations.
To import the email addresses from within ASCII text file (filename.txt) into your address book, open your email client program and use its file import utility. Launch the utility and then import the file from the location where the file was saved. Depending on which email client program you are using, it may require a file extension of csv, meaning comma separated value format (filename.csv). Simply, just rename the ASCII text file extension from txt to csv.
Unregistered Version - Demonstration Mode
The shareware version of this program is limited to exporting up to a maximum of 5 real email addresses. However, there is no limit if you use the test email address extension ".cam". The sample email addresses initially provided with this program all have the extension ".cam".
If you purchase and register this program, it will continue to function normally without the 5 email address limit !
¹ This 65,536 value is Excel 97, 2000, and 2002's maximum row limit. Excel 95's limit is 16,384.