Search  Rules  Login
TheBat English » The Bat! - Configuring the E-mail Client
Pages: 1
RSS
Excel CSV email list to address book, Trying unsuccessfuly to import email list from Excel that works for for sending bulk email to a group
 
#1
0  
I've tried support, but I'm not getting very far. I have a list of email addresses ( around 350) taken fr om my practice management system (I'm a veterinarian)  and I want to import it into the address book of a new group I have made called Vets2024.

I've now got a list of email addresses, separated by commas, ( which I made by importing it into my webmail server's facility rather than The Bat!) and when I enter them into the BCC box in The Bat! and try and send the email I get error messages saying anything from "server reports unroutable address" to server reports "my email address"". The same thing happens if I try importing the email list from a CSV file directly into The Bat!  and use them.

I think I may have managed to send them all by using the webmail section on the server wh ere my email accounts are hosted, but it was a PITA as the maximum number of emails that could be sent out at once was 100 and involved a lot of unnecessary work
.

I am sure I managed to do a similar thing 5 years ago using The Bat! but I just can't seem to get it to work this time. If I try a test email using only 3 email addresses, separated by only commas, in the BCC box then they do get sent.

Does anyone have an idea what is going on?

David B
 
 
 
#2
0  
Fr om those errors, it sounds like you may have a few invalid addresses in the address book.

You may also run into limitations set by your mail provider (like the 100 BCC addresses you already noticed, but they may also have a lim it of e.g. no more than 100 outgoing messages per hour - please ask them and adjust your method as necessary).

Instead of entering all those addresses in the BCC field you can also just enter the handle of that address book group (but it should not contain more entries than allowed by your provider - so, you may have to split the address book group into multiple groups of e.g. 100 each, and create several messages, one for each different group).

For more information about address book groups and mass mailing see https://www.ritlabs.com/en/support/help/70/#6637
I volunteer as a moderator to help keep the forum tidy. I do not work for Ritlabs SRL.
 
 
 
#3
17.2714  
Due to the limit of 100 shipping addresses, the entire list should be divided into smaller fragments, e.g. 70 addresses each. Instead of using a CSV file, convert it to a text file. Addresses in a simple text file can be easily imported to The Bat! address book. The condition for efficient import: each address must be on a separate line, i.e. commas in the CSV file must be replaced with newline characters (e.g. in MS Word, replace commas with a new paragraph character ^p).

Then, create 5 groups in the address book. I suggest group names: Vets2024_01, Vets2024_02, ..., Vets2024_05. Import the addresses from the text files to individual groups. With such an address book built, you can enter the group address in the BCC field in the message editor, i.e. Vets2024_01<list>, in the next message Vets2024_02<list>, etc.

You can automate message creation by using a filter and a quick template. In the quick template, enter the content of the message to be sent. Here is my working proposal:

1. Prepare the groups of recipients described above in the address book (group names as I provided).

2. Prepare a quick template for the message, giving it an identifier, e.g. Out_Template.

3. Paste the filter given below (using the Ctrl-C/Ctrl-V method) into any filter group (for an account, as a common filter, for incoming mail - it doesn't matter):
Code
$$$$ TB! Message Filter $$$$
beginFilter
UID: [FC5BA98A.01D48895.7FC672C3.0C318FD6]
Name: Vets_Mailing
Filter: {\0D\0A\20`21\0D\0A}
Tag: MM
CreateMessage template %QInclude(Out_Template)%-\0D\0A%BCC\3D\22Vets2024_01<list>\22%-\0D\0A queue
CreateMessage template %QInclude(Out_Template)%-\0D\0A%BCC\3D\22Vets2024_02<list>\22%-\0D\0A queue
CreateMessage template %QInclude(Out_Template)%-\0D\0A%BCC\3D\22Vets2024_03<list>\22%-\0D\0A queue
CreateMessage template %QInclude(Out_Template)%-\0D\0A%BCC\3D\22Vets2024_04<list>\22%-\0D\0A queue
CreateMessage template %QInclude(Out_Template)%-\0D\0A%BCC\3D\22Vets2024_05<list>\22%-\0D\0A queue
IsActive
IsHotkey
IsHotkeyOnly
Ignore
IsSendQueue
Hotkey 16506
endFilter

4. The filter should be started with the Ctrl-F11 key combination, which is why you need to set it in the filter options.

5. Now just highlight any message anywhere and press Ctrl-F11. In the "Outbox" folder there will be 5 messages with the next group addresses in the BCC field. You can review them or send them immediately using The Bat! menu.
 
 
 
#4
2009.7393  
Many thanks.  It's all working now. I've made 10 address book groups with about 30 in each and I've just sent the first one and it works. I will send the rest over the next 2 days.
 
 
 
#5
0  
I spoke too soon.  I've tried sending the second batch which contained few email addresses than the first one ( 35 in first, 30 in second)  and it wont send. I get a message "message not sent: server reply- unroutable address"

The way the email addresses appear in the To and BCC boxes is just like they were in the successfully sent batch

eg

[email addresses deleted by moderator - Daniel]
 
 
 
#6
0  
It sounds like there was (at least) one faulty address in your list. I don't know how that has affected the mailing out of the other messages.

When I sent out mass mailings in the past, I made my own address the first and last address in the list to have a simple way of verifying that the messages went out. Maybe you can check the log files of your account to see which messages went out or not (the Properties of your account may allow you to activate more logs or to make them 'verbose' for future use - but I don't know if the additional data would actually help).
I volunteer as a moderator to help keep the forum tidy. I do not work for Ritlabs SRL.
 
 
 
#7
0  
"Unroutable" almost certainly means a bad domain part of some address -- that is, the part after the @ sign. The domain part might be an IP address, or might look good but fail DNS lookup. If they all look OK visually, then perhaps the best way to diagnose is to split the group into smaller group, then split again whichever still fails, etc until there's only one address.
 
 
 
#8
0  
I had similar trouble before, and for me, enabling OAuth 2.0 from my Gmail settings and allowing access for less secure apps fixed it. Also, I sometimes use advanced excel formulas & functions examples to quickly prepare logs and filter out issues in my email reports—combining these tools really made it easier to track send/receive problems in The Bat!.
Edited: Alek Lyhe - 24 October 2025 11:33:03
 
 
 
Pages: 1