Re: mail merge
Hello Roelof, Wednesday, October 7, 2015, 1:23:55 AM, you wrote: RO> Hallo TBUDL, RO> Op dinsdag 6 oktober 2015, 22:55:52, schreef Jenny Zonneveld: >> I haven't needed to do this for a very long time but I need to send >> a mailing based on an Excel sheet, the mail needs to contain some of >> the info contained in the spreadsheet (besides the name and e-mail address) RO> Save the excel sheet as .csv RO> Import the .csv in an address book group. RO> In order to maintain the integrity of your regular address book, I RO> suggest that you create a separate address book file just for this RO> action. RO> Besides the name and email you need to import the additional data in RO> that address book to, configure the import to insert those data in RO> fields that you don't use. that might be the home fax number, the RO> street of the personal or busines addresses, etc. RO> Create a template, for the additional data you insert the macro that RO> indicates that field, like %ABToFAX RO> The mass mailing has unexpected addresses when the address that it's RO> looking for occurs multiple times in the address book. Therefore RO> before you run the mass mailing, it's best to temporarily remove your RO> regular address book from your TB setup. (That's another reason to RO> import in a separate file.) RO> Afterwards you simply place your regular AB back and delete the RO> specioal import. Thank you - I'll start experimenting! -- Kind regards, Jenny Zonneveld Current version is 6.6 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Mod: Untrimmed reply (was: mail merge)
Hallo Jenny, On Wed, 7 Oct 2015 08:40:41 +0200GMT (7-10-2015, 8:40, where I live), you wrote: JZ> Thank you - I'll start experimenting! Note: This moderator's interjection is a note to all readers and not just to the person being replied to, even if their post may have instigated this reply. Please don't feel singled out Jenny. )<)))'> Please trim replies to context. A sure fire indicator that insufficient trimming has been done is that the original signature and list footer remain in the quoted text. To find out why these MOD messages are posted to the list instead of private mail, please read the welcome message you received when you subscribed. Thank you. -- Groetjes, Roelof Moderators - The people USERS laugh at! Current version is 6.6 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
mail merge
Hi everyone, I haven't needed to do this for a very long time but I need to send a mailing based on an Excel sheet, the mail needs to contain some of the info contained in the spreadsheet (besides the name and e-mail address) Could some kind soul point me in the right direction for such functionality in TheBat! please. I imagine I need to set up a template: - how do generate a message for each line in the spreadsheet (or selected lines) and queue the mail so I can review it before sending, - how do I include data from the spreadsheet per recipient. Thanks in advance for you help! -- Kind regards, Jenny Zonneveld The Bat! 6.8.8 Windows 7 6.1 7601 Service Pack 1 Current version is 6.6 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: mail merge
Hallo TBUDL, Op dinsdag 6 oktober 2015, 22:55:52, schreef Jenny Zonneveld: > I haven't needed to do this for a very long time but I need to send > a mailing based on an Excel sheet, the mail needs to contain some of > the info contained in the spreadsheet (besides the name and e-mail address) Save the excel sheet as .csv Import the .csv in an address book group. In order to maintain the integrity of your regular address book, I suggest that you create a separate address book file just for this action. Besides the name and email you need to import the additional data in that address book to, configure the import to insert those data in fields that you don't use. that might be the home fax number, the street of the personal or busines addresses, etc. Create a template, for the additional data you insert the macro that indicates that field, like %ABToFAX The mass mailing has unexpected addresses when the address that it's looking for occurs multiple times in the address book. Therefore before you run the mass mailing, it's best to temporarily remove your regular address book from your TB setup. (That's another reason to import in a separate file.) Afterwards you simply place your regular AB back and delete the specioal import. -- Groetjes, Roelof Current version is 6.6 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Mail Merge?
I have a number of text files of the following form: HEADER LINE Students: Name e-mail address, Name e-mail address From: My Name my e-mail address MORE TEXT Is there an easy way to have The Bat! read these files in, extract the e-mail addresses, place them in the To: field, fill-in a subject, and place the entire contents of the file in the body? I'm not scared of regular expressions, but I'm no wizard either. -- Chris Using The Bat! v3.85.03 on Windows XP 5.1 Build 2600 Service Pack 2. Accessing a POP3 mailbox. To define recursion, we must first define recursion. pgpZxO6XOFBKd.pgp Description: PGP signature Current version is 3.85.03 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Mail Merge?
Hallo Chris, On Thu, 7 Dec 2006 13:52:59 -0600GMT (7-12-2006, 20:52 , where I live), you wrote: C I have a number of text files of the following form: C HEADER LINE C Students: Name e-mail address, C Name e-mail address C From: My Name my e-mail address C MORE TEXT Rather odd text files. ;-) C Is there an easy way to have The Bat! read these files in, extract the C e-mail addresses, place them in the To: field, fill-in a subject, and C place the entire contents of the file in the body? Sure, can be done. No problem whatsoever. But your subject says mail merge and that's not quite same as what your asking for. A mail merge (especially one using TB's mass mailing capabilities) would be difficult/impossible. C I'm not scared of regular expressions, but I'm no wizard either. I'm no wizard either, but here's my solution: ,- [ ] | %SetPattRegExp='(?is)(.*?)\nStudents:\s(.*?)\nFrom:\s(.*?)\n(.*)'%- | %RegExpBlindMatch='%Put(C:\Temp\students.txt)'%- | %To=%To=%SubPatt='2'%- | %Subject=%SubPatt='1'%- | %From=%SubPatt='3'%- | %SubPatt='4' `- In order to test it, I created a file C:\Temp\students.txt with contents in your format and it worked like a charm. A few notes. I used your 'HEADER LINE' as subject, therefore it needs to be a single line not starting with 'Students: ' as that string is the separator I use to find where your addressees are listed. You can use something else as source for the subject, that won't really break the template. A possible enhancement would be to make your students' addresses invisible for each other by placing them in the BCC: header. In order to do that you have to change the line: %To=%To=%SubPatt='2'%- into these two lines: %To=%To=%SubPatt='3'%- %BCC=%SubPatt='2'%- That will cause your own address to be placed in the To: header and all other recipients in the BCC: header. A definite restriction is that all recipients' addresses (except for the last) need to be followed by an comma as TB needs that comma to separate them. Another restriction is that all addresses with a name with points need to be enclosed between quotation marks, otherwise it would contain an illegal dot in the name. Harvey L. Oswald [EMAIL PROTECTED] is an illegal construct in an address header, while Harvey L. Oswald [EMAIL PROTECTED] computes just fine. I'm CC-ing this answer to tbtech as it's definitely too technical for tbudl. Follow-ups need to go there too. -- Groetjes, Roelof Windows 95: Making Windows work just like a Mac did 10 years ago! http://www.voormijalleen.nl/ The Bat! 3.86.8 ALPHA (beta) Windows XP 5.1 Build 2600 Service Pack 2 1 pop3 account, server on LAN OTFE enabled P4 3GHz 2 GB RAM pgpjhVTsRz08F.pgp Description: PGP signature Current version is 3.85.03 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Mail Merge take 2
Using The Bat! v1.62i on Windows XP 5.1 Build 2600 Service Pack 1 A few days ago, someone else asked about mail merge. I have a related question: I store numeric information about contacts in a database. I can export this to a CSV, but have no idea how to use that in a mail merge. For example, one field gives the number of times an event occurred, which is different for each contact. Are such merge variables possible with TB? If so, how should I go about using them? TIA, -- Geoff Lane Cornwall, UK Psychoceramics ... the study of crackpots. Current version is 1.62 | Using TBUDL information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Mail Merge take 2
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Geoff, @30-Mar-2003, 16:20 Geoff Lane [GL] in mid:[EMAIL PROTECTED] said: GL I store numeric information about contacts in a database. I can export GL this to a CSV, but have no idea how to use that in a mail merge. For GL example, one field gives the number of times an event occurred, which GL is different for each contact. GL Are such merge variables possible with TB? If so, how should I go GL about using them? First, import the CSV into an AB group. Put the numeric data into a spare AB field (there are plenty to chose from, for instance 'Fax number'. Now compose a QT macro for the Mass Mail you want to do and use the %ABtoFax macro to refer to the data in question. Query it with a construct like this: %If:'%ABtoFax'='1':' first time ':' not the first time ' Does that help? - -- Cheers -- .\\arck D Pearlstone -- List moderator TB! v1.63 Beta/7 on Windows 2000 5.0.2195 Service Pack 2 ' -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1rc1-nr1 (Windows 2000) iD8DBQE+hxqTOeQkq5KdzaARAtxqAJ0aZkDyYvSS9RBuL6ZReIPVT9FkXACfchXK JYCtdQKjHKjaxkhYo5Qgqsc= =f2EL -END PGP SIGNATURE- Current version is 1.62 | Using TBUDL information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Mail Merge take 2
On 30 March 2003, 17:25, Marck D Pearlstone wrote: Now compose a QT macro for the Mass Mail you want to do and use the %ABtoFax macro to refer to the data in question. Query it with a construct like this: %If:'%ABtoFax'='1':' first time ':' not the first time ' Does that help? ~~~ Thanks, that was the part I was missing. When I clicked the Macros button, I couldn't find anything for the address book fields. Now that you've mentioned it, I've found the full list in the Help. Thanks again, -- Geoff Lane Cornwall, UK -- Using The Bat! v1.62i on Windows XP 5.1 Build 2600 Service Pack 1 I procrastinate, therefore I will be. Current version is 1.62 | Using TBUDL information: http://www.silverstones.com/thebat/TBUDLInfo.html
Mail Merge?
Call me braindead, but for the life of me I cannot figure out or find any mention in the Help file of how to do a mail merge. Basically, I have a spreadsheet - or it could be a text file - with a person's email address, name, and another specific piece of info I need to send to that individual. I would like that to be pasted into a general message and have each message created automagically and POOF!!... email is sent. I can do this with Outlook but prefer not to for several reasons. Thanx in advance!! .jim. Current version is 1.62 | Using TBUDL information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Mail Merge?
Hallo Jim, On Tue, 25 Mar 2003 08:04:49 -0500GMT (25-3-03, 14:04 +0100, where I live), you wrote: JRJ Call me braindead, but for the life of me I cannot figure out or JRJ find any mention in the Help file of how to do a mail merge. JRJ Basically, I have a spreadsheet - or it could be a text file - JRJ with a person's email address, name, and another specific piece JRJ of info I need to send to that individual. Turn that file into a csv file (csv=comma separated value) import that into an address book (or an address book group) create a quick template that can be used for new message/mass mailing select the wanted addresses in the AB and then: file - mass mailing using template - select the needed template and you're done. -- Groetjes, Roelof Current version is 1.62 | Using TBUDL information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re[3]: Mail Merge
Hello Miguel, Monday, April 08, 2002, 12:02:47 AM, you wrote: MAU When VA started its main market was as an OLR for Compuserve Forums MAU (including binary libraries) and CIX, although it could also handle MAU Internet mail and Usenet. That perhaps made it some what peculiar in MAU some concepts and structure and with a steep learning curve at first. MAU But it was great for a number of years. And actually it is still is, MAU but it is now a little outdated in some features. The CIX off-line reader AMEOL is still great for use with a conferencing system like CIX itself - but I note that many of the CIX support staff themselves use The Bat! for mail. Using The Bat! v1.53bis on Windows 98 4.10 Build 1998 -- Best regards, myobmailto:[EMAIL PROTECTED] Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
Miguel, I would also probably go back to VA if it was resurrected. But, so far, I don't believe in miracles. Well, a little bird just told me miracles do happen. Can't say more just yet. g -- Ian Petersen Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Ian, Well, a little bird just told me miracles do happen. Can't say more just yet. g I'll be listening :-) -- Best regards, Miguel A. Urech (El Escorial - Spain) Using The Bat! v1.60c Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Sunday, April 7, 2002, 10:47:22 AM, you wrote: Miguel, I would also probably go back to VA if it was resurrected. But, so far, I don't believe in miracles. Well, a little bird just told me miracles do happen. Can't say more just yet. g I've just joined this list and seen your comments about VA. Without doubt, VA shaped my Internet experience when I first plugged my modem into the wall some years ago. Like you, I just hope someone picks it up and gives it a bit of oil before it seizes up finally. I still use the newsreader and just _can't_ get to grips with any of the alternatives. Nice to see this list. -- Regards, Clive Taylor Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Ian, Sunday, April 7, 2002, 4:47:22 AM, you wrote: IP Well, a little bird just told me miracles do happen. Can't say more IP just yet. g I heard this exact statement months ago. Am I listening to a broken record? I'll believe it when I see it, and will keep my one good eye open looking for it. vbg BTW that little bird wouldn't happened to be named Amrik? After using TB! for only a few days I will say that I like it. Since I am only on the 30 day trial, I will probably purchase it without any regard to the VA situation. -- Best regards, Gregmailto:[EMAIL PROTECTED] Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 @ 12:23:24 -0500 [ Sun, 7 Apr 2002], Greg Strong [GS] wrote these words of wisdom: ... GS After using TB! for only a few days I will say that I like it. GS Since I am only on the 30 day trial, I will probably purchase it GS without any regard to the VA situation. I've tried VA and I can sympathise with its former users. VA has quite an unusual/different approach to design and how things are done. I tried it especially for Newsgroups, but its methods were so different that I couldn't make the change, especially since I wasn't convinced that it provided a better solution for my needs than Agent or X-News did. I guess the reverse would also apply in that migrating from VA to TB! could be an awkward ride at first. But there are features in TB! that can make you feel at home. It's just a different approach to get accustomed to. Good luck! - -- Allie C Martin (List Moderator and fellow end user) PGP Public Key - mailto:[EMAIL PROTECTED] ®TB! v1.60c on Windows XP 5.1.2600 _ -BEGIN PGP SIGNATURE- iEYEARECAAYFAjywiT4ACgkQV8nrYCsHF+L2MwCdF1q3OyXuCITqwrFagekQmixB jF4AnjeZdHlopSs2LdSYv0p6mibBldwZ =hMAP -END PGP SIGNATURE- Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In a message dated, Sun, 7 Apr 2002 13:34:36 -0500, Greg Strong [GS] wrote: ... GS If they would open their mind to achieving the same goal a GS different way, then the learning would probably be easier. Amen to that. :-) - -- Allie C Martin (_ List Moderator and fellow end user __) PGPKey - mailto:[EMAIL PROTECTED] ®TB! v1.60c on Windows XP 5.1.2600 _ -BEGIN PGP SIGNATURE- iEYEARECAAYFAjywlAwACgkQV8nrYCsHF+IO8gCgo/LgnyNIDmvwMySBiYbCx0H7 cSUAoLxGpqkcWrxUT6/WgcVjIkauHay/ =nMrg -END PGP SIGNATURE- Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Allie, Sunday, April 7, 2002, 1:00:29 PM, you wrote: ACM I've tried VA and I can sympathise with its former users. VA has quite ACM an unusual/different approach to design and how things are done. I ACM tried it especially for Newsgroups, but its methods were so different ACM that I couldn't make the change, especially since I wasn't convinced ACM that it provided a better solution for my needs than Agent or X-News ACM did. IMHO VA was NOT the best at everything. It was the fact that ONLY 1 user interface was needed for CIS forums, e-mail, newsgroups. It not only covered ALL the bases, but did so in ONLY 1 pass over multiple news servers, e-mail accounts, and CIS. The fact you could use 1 program to do ALL pretty good was what endured me to VA. ACM I guess the reverse would also apply in that migrating from VA to TB! ACM could be an awkward ride at first. But there are features in TB! that ACM can make you feel at home. It's just a different approach to get ACM accustomed to. Interesting ride is more like it. What it did was force me to look at other programs which expanded my experience. The most interesting part is reading how loyal users defend the program of their choice. The learning curve is NOT an easy hill to climb especially when you are trying to be productive. In most instances their defense is rooted in the fact that they've used it for so long, and feel comfortable with it. If they would open their mind to achieving the same goal a different way, then the learning would probably be easier. -- Best regards, Gregmailto:[EMAIL PROTECTED] Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
Greg, I heard this exact statement months ago. Am I listening to a broken record? Quite possibly. But I did say I JUST - as in this weekend - heard the little bird sing. I am not, however, privy to any details. All I can say is that it was a happy song. BTW that little bird wouldn't happened to be named Amrik? No. Now that's enough ornithology for today. g -- Ian Petersen Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[3]: Mail Merge
Hello Greg, After using TB! for only a few days I will say that I like it. Since I am only on the 30 day trial, I will probably purchase it without any regard to the VA situation. Smart decision. Assuming they resumed development immediately (and with Pete in the team), I don't think they could come out with a decent new version in less than one year. Some parts of VA are quite old code that needs complete re-writing and that is not done over a weekend. -- Best regards, Miguel A. Urech (El Escorial - Spain) Using The Bat! v1.60c Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Allie, I've tried VA and I can sympathise with its former users. VA has quite an unusual/different approach to design and how things are done. When VA started its main market was as an OLR for Compuserve Forums (including binary libraries) and CIX, although it could also handle Internet mail and Usenet. That perhaps made it some what peculiar in some concepts and structure and with a steep learning curve at first. But it was great for a number of years. And actually it is still is, but it is now a little outdated in some features. -- Best regards, Miguel A. Urech (El Escorial - Spain) Using The Bat! v1.60c Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ian, @06 April 2002, 08:55:21 +0200 (07:55 UK time) Ian Petersen wrote in [EMAIL PROTECTED]">mid:[EMAIL PROTECTED] Yes, sooner or later we will see more VA users here. Unless VA, by some miracle, is resurrected from the netherworld. If that ever happens I, for one, am probably outta here! ... unless you start using the TB features of TB and not just looking for ways in which you can emulate VA. TB has some amazing and unique talents which I have been unable to replace using other clients. It takes some setting up and getting used to, but now I would find it very hard to replace it with anything else. Just as you are missing VA, I guess. - -- Cheers -- .\\arck D. Pearlstone -- List moderator TB! v1.60c-14F4B4B2 on Windows 2000 5.0.2195 Service Pack 2 · -BEGIN PGP SIGNATURE- iD8DBQE8rsE5OeQkq5KdzaARAtXaAJ9GMHbLzCUrr6diJgwQjYQsJiEckgCfd4uU j9gsTU+ELxWQo+MTpvuwxD8= =YMeq -END PGP SIGNATURE- Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[5]: Mail Merge
Hello Greg, Either here or some where else. Technology moves forward. Without development where does that leave VA? I think we both know the answer to this question. Yes, we do. It was a hard decision for me after so many years, but here I am. -- Best regards, Miguel A. Urech (El Escorial - Spain) Using The Bat! v1.60c Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Ian, Unless VA, by some miracle, is resurrected from the netherworld. If that ever happens I, for one, am probably outta here! I would also probably go back to VA if it was resurrected. But, so far, I don't believe in miracles. -- Best regards, Miguel A. Urech (El Escorial - Spain) Using The Bat! v1.60c Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Jan, Just curious - on what basis would you think this w/o having tried it? I didn't say I haven't tried it, I said I haven't _used_ it. A slight difference, but perhaps significant. Just the same that, to me, there is a difference between mass mailing and mail merge. I have read all I could find about mass mailing with TB! and set up one, although I didn't send it. It may well be true. I certainly wouldn't know because I've never used Virtual Access but I'd be interested in hearing how you arrived @ this conclusion given your current TB! experience(s). OK, let me give you an example. I have a DB/Contact Manager with all my clients (hundreds, fortunately :) and every months I want to send a letter (e-mail) to those whose maintenance contract will expire within one month. Aside of their name and address (e-mail address if done by e-mail) I need to refer to their UserID, numbers of licenses, date that the contract expires, the name of the distributor that they have to contact (or will contact them) and perhaps some other field from the DB. You can obviously do this with TB! but it is not straight forward. To start, each months I would have to export the corresponding list of clients and create an address book in TB with their name and address. But, what about the rest of the variable fields I need to include in the messages? How did I do it with VA?. I would select those clients whose contract would expire within one month and export the desired fields to a CSV file. Any DB I know of can do that. Now, in VA, I do need to set a template (much like a QT in TB) in which I can refer to the CSV values by column numbers: %1%, %2%... %n%. So that if I had exported to CSV file the fields: Name, Email, Salutation, No. of licenses, Exp. Date, etc., in this order, I could write my template something like: -- To: %1% %2% Subject: Maintenance expiration %3%, Our records show that the Maintenance contract for your %4% licenses of Product are due to expire on %5%blah, blah, blah. -- And now, even without saving the template if I have just composed it, or by opening in the editor if previously composed, all I have to do is to click on the E-mail merge button which will request the name of the CSV file and... voila!, there go the umpteen fully customised messages. -- Best regards, Miguel A. Urech (El Escorial - Spain) Using The Bat! v1.60c Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Marck, It isn't. TB can only mass mail using the Address Book. You can import CSV address lists into an address book group and mass-mail from there. I assume you have seen my reply to Jan. How do I manage the rest of the variable fields I want to use in my message? That's why I make a difference between mass mailing and full mail merge. -- Best regards, Miguel A. Urech (El Escorial - Spain) Using The Bat! v1.60c Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Miguel, @06 April 2002, 12:50:35 +0200 (11:50 UK time) Miguel A. Urech wrote in [EMAIL PROTECTED]">mid:[EMAIL PROTECTED] It isn't. TB can only mass mail using the Address Book. You can import CSV address lists into an address book group and mass-mail from there. I assume you have seen my reply to Jan. How do I manage the rest of the variable fields I want to use in my message? I don't know how you do it, but I do it by temporarily abusing an address book group, using some of the superfluous fields in the address book to hold the extra data. It can lead to some obtuse namings but works very well. The %ABTOblahblah macros will allow you to grab any field from an address book record in the MM Quick Template. Furthermore, Regular expression and %IF macros allow some superb per-target programmability. Immensely flexible! The CSV importer will allow you to map any import column to any address book field. Importing to a group keeps things separate. I only see a slight overhead in thought process in setting up the MM QT and an extra import stage. Other than that, I only see parallel functionality with potentially superior intelligence available. I'm not saying it's as easy to use as VA's mail merge. It clearly is not. I'm just saying that it is just as capable and possibly more so. That's why I make a difference between mass mailing and full mail merge. ... and that's why I don't g. - -- Cheers -- .\\arck D. Pearlstone -- List moderator TB! v1.60c-14F4B4B2 on Windows 2000 5.0.2195 Service Pack 2 · -BEGIN PGP SIGNATURE- iD8DBQE8rtm5OeQkq5KdzaARAq1cAJ9+qlpD7ShCUHatr9mnCR+FpoymuwCg8c9z g+UI4VZbbXhWMM4tKcace/c= =qzZA -END PGP SIGNATURE- Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Marck, ..snipped.. I'm not saying it's as easy to use as VA's mail merge. It clearly is not. I'm just saying that it is just as capable and possibly more so. You are right, it is not as easy and straight forward as with VA. And I think I never said it was not possible with TB, I also though about cheating and using many of the hardly used (at least by me) AB fields. But, if I do that, I will at least need two extra steps: importing the CSV file into the AB and deleting the AB when finished as, in my case and example, the next month the addressees will be different. I still have to get acquainted with some of the many macros available in TB! and with RegExp in general. Who knows, maybe there is some hidden way of using the CSV file directly -- Best regards, Miguel A. Urech (El Escorial - Spain) Using The Bat! v1.60c Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
Marck, TB has some amazing and unique talents which I have been unable to replace using other clients Undoubtedly. TB is certainly capable, in many ways, of a lot more than VA ever has been. My main gripe with TB is many of its talents are very difficult or long-winded to use and so poorly documented that I, for one, simply give up trying to figure them out. -- Ian Petersen Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Mail Merge
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello TBUL, Does the TB! provide mail merge capabilities? I did a find in help on mail merge without luck. The mail merge capability would create individual outgoing messages. The only difference would be who the message is going and change variables within the body of message. NO I AM NOT TRYING TO CREATE SPAM, so please do not be lead to this conclusion when I ask the question. - -- Best regards, Greg mailto:[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6-2 (MingW32) - GPGshell v2.28 Comment: (0x88CEFF36) Key ID for Greg Strong iD8DBQE8rgXwKOQ6jYjO/zYRAqvoAJsGD+RcrGxxGvg+pn5gek+FR7lrtgCgv0gS IHq41ey3TV8gDCWZqKuzUpQ= =OhmQ -END PGP SIGNATURE- Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
Greg, Does the TB! provide mail merge capabilities? I did a find in help on mail merge without luck. The mail merge capability would create individual outgoing messages. The only difference would be who the message is going and change variables within the body of message. Yes, - Create a quick template and mark it for mass mailing - select the addresses in your address book and select the menu option File MassMailing using template It is as easy as that (although I must admit that the first step is easy to overlook) -- Robert van der Hulst Solution Application Software www.sas-software.nl [EMAIL PROTECTED] Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
Hi Greg, Nice to see you here :-) Does the TB! provide mail merge capabilities? I see you already got a reply. I haven't used mass mailing yet, but I think it would be easier if I could use a CSV text file, like with Virtual Access, instead of an Address Book. -- Best regards, Miguel A. Urech (El Escorial - Spain) Using The Bat! v1.60c Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Miguel, Friday, April 5, 2002, 2:55:55 PM, you wrote: MAU I see you already got a reply. I haven't used mass mailing yet, but I MAU think it would be easier if I could use a CSV text file, like with MAU Virtual Access, instead of an Address Book. Well without using it I couldn't say. I will say the mail merge in VA was difficult at first, but once grasped most definitely a great feature. I am sure the initial learning curve was due to the fact it was mistakenly omitted from the help file. -- Best regards, Gregmailto:[EMAIL PROTECTED] Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Miguel, Friday, April 5, 2002, 2:55:55 PM, you wrote: MAU Nice to see you here :-) Thanks! I have to get use to the inbox and outbox concept used in most e-mail programs today. After using VA for few years it put everything in one folder. When I created the filters for the mail lists I belong, I created both incoming and outgoing rules for 1 mail list. Now I have duplicates of messages that I sent. Duh! vbg I saw Mr. Trilling ask you the other day about TB! in the Yahoo group. It looks like the old faithfuls of VA are recognizing the obvious. Oh well you just have bear running over those first few learning curve hills. -- Best regards, Gregmailto:[EMAIL PROTECTED] Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[3]: Mail Merge
Hi Greg, When I created the filters for the mail lists I belong, I created both incoming and outgoing rules for 1 mail list. Now I have duplicates of messages that I sent. Duh! vbg Well, you have found out by yourself that, for mail lists, you don't need an outgoing filter (or if you use it you can send messages directly to trash) because you will get your own message back from the list. I saw Mr. Trilling ask you the other day about TB! in the Yahoo group. Yes, sooner or later we will see more VA users here. -- Best regards, Miguel A. Urech (El Escorial - Spain) Using The Bat! v1.60c Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
Good night Greg, It was foretold that on 5-4-2002 @ 14:16:13 GMT-0600 (which was 22:16 where I live) Greg Strong wrote and spread these wise comments on Mail Merge: snipped a bit GS Does the TB! provide mail merge capabilities? I did a find in help on mail GS merge without luck. The mail merge capability would create individual GS outgoing messages. Is this what you are looking for: While using of BCC fields creates a single message sent to multiple people, Mass Mailing can create personalised messages so the recipient can see his/her name and address in the TO field and the message text can contain the recipient-specific information like his/her title, greeting accordingly to the gender defined in your address book, company name, etc. To use Mass Mailing feature, you should create a Quick template and set the option to use it for new messages/Mass mailing. Then, select addresses from your address book and use the File|Mass mailing using template menu command of the address book window... It's (you may or not may not believe it) actually an excerpt of the helpfile (keyword Massmailing) -- Best regards, Lucmailto:[EMAIL PROTECTED] --- Powered by The Bat! version 1.60c with Windows 2000 (build 2195), version 5.0 and using the best browser: Opera. Few women admit their age. Few men act theirs. Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
Hello Miguel. At 3:55 PM on Friday, April 05, 2002 you wrote the following about [Mail Merge]: Does the TB! provide mail merge capabilities? Miguel I see you already got a reply. I haven't used mass Miguel mailing yet, but I think it would be easier if I Miguel could use a CSV text file, like with Virtual Access, Miguel instead of an Address Book. Just curious - on what basis would you think this w/o having tried it? It may well be true. I certainly wouldn't know because I've never used Virtual Access but I'd be interested in hearing how you arrived @ this conclusion given your current TB! experience(s). -- Jan Rifkinson Ridgefield, CT USA TB! V1.60c/W2K_SP2 ICQ 41116329 Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Jan, @06 April 2002, 18:24:30 -0500 (00:24 UK time) Jan Rifkinson wrote in [EMAIL PROTECTED]">mid:[EMAIL PROTECTED] It may well be true. It isn't. TB can only mass mail using the Address Book. You can import CSV address lists into an address book group and mass-mail from there. There's a good write up on using Mass Mailing in the FAQ. - -- Cheers -- .\\arck D. Pearlstone -- List moderator TB! v1.60c-14F4B4B2 on Windows 2000 5.0.2195 Service Pack 2 · -BEGIN PGP SIGNATURE- iD8DBQE8rktGOeQkq5KdzaARAnFFAJ0Umk7d6KC3W2eR3wCDzR9wjqMdZwCeJpZt kRGz85K0dMHXi4crFo3ehW4= =YVrk -END PGP SIGNATURE- Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Luc, Friday, April 5, 2002, 5:19:14 PM, you wrote: L It's (you may or not may not believe it) actually an excerpt of the L helpfile (keyword Massmailing) Yeah I hear you. Who would have thunk. Mail Merge = Mass Mailing? I never heard it referred to with this term. :) -- Best regards, Gregmailto:[EMAIL PROTECTED] Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[4]: Mail Merge
Hello Miguel, Friday, April 5, 2002, 4:00:59 PM, you wrote: MAU Yes, sooner or later we will see more VA users here. Either here or some where else. Technology moves forward. Without development where does that leave VA? I think we both know the answer to this question. -- Best regards, Gregmailto:[EMAIL PROTECTED] Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
Good morning Greg, It was foretold that on 6-4-2002 @ 22:28:42 GMT-0600 (which was 6:28 where I live) Greg Strong wrote and spread these wise comments on Mail Merge: snipped a bit GS Yeah I hear you. Who would have thunk. Mail Merge = Mass Mailing? I GS never heard it referred to with this term. :) Ritlabs works in mysterious ways ;-) -- Best regards, Lucmailto:[EMAIL PROTECTED] --- Powered by The Bat! version 1.60c with Windows 2000 (build 2195), version 5.0 and using the best browser: Opera. It is often said: Always put off tomorrow what you can do today, but if the toilet is out of order, I am not sure if that still holds. Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re[2]: Mail Merge
Hello Jan, Friday, April 5, 2002, 5:24:30 PM, you wrote: JR Just curious - on what basis would you think this w/o JR having tried it? I don't mean to defend VA or TB!, but maybe you don't want to put the recipients into your address book for starters. Now I may have you thinking this is is a spam junkie. Wrong again! For example how about you are contacting people professionally over the phone who provide you their e-mail address. They agree to receive an e-mail from you with regard to your telephone conversation. During the day you input all the contact information necessary into a database. At the end of the day you run a query for all those agreed to the e-mail and save it to a CSV file. You merge the CSV file with a standard e-mail regarding your professional telephone conversation. Whalla you have an individual e-mail for every individual you spoke to that day. At this point in time I do NOT want them in my address book. The purpose of the e-mail was to provide contact information and resources available to them on the net with regard to following up your telephone conversation. The recipient can now decide according to their schedule when to look at the resources and contact you. If they are NOT interested I do NOT want them in my address book. Just more work like maintenance on the address book! -- Best regards, Gregmailto:[EMAIL PROTECTED] Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
Re: Mail Merge
Miguel, Yes, sooner or later we will see more VA users here. Unless VA, by some miracle, is resurrected from the netherworld. If that ever happens I, for one, am probably outta here! -- Ian Petersen Current Ver: 1.60c FAQ: http://faq.thebat.dutaint.com Unsubscribe: mailto:[EMAIL PROTECTED] Archives : http://tbudl.thebat.dutaint.com Moderators : mailto:[EMAIL PROTECTED] TBTech List: mailto:[EMAIL PROTECTED]
