Re: Template problem: macros to identify sender name and address
Luca: MFPA: Can you alter the order of the fields exported by your Access Query so that the string TB! stores in the email address AB field is unique for each AB record, and the actual email address gets stored in a different AB field? Then %ABtoPPP would select the correct AB entry each time, so that you get the correct Username and Password for the course in the email body. And you would need to add a macro to substitute in the email address afterwards. For example, if you stored the email address in the State field, it might be something like:- %To = %ToName %ABToState Disclaimer: I have not tested this. That looks brilliant and promising a trick. I'll test it as soon as I can then report here. Seems not to work ): the variable %TO only adds a recipient to the To: field, doesn't substitute the default value that's inevitably formed by the two fields Name email, and email uniquely identifies the AB entry to pick values from. That seems to me at a first attempt. But I'm going to try harder later. -- Luca - e-mail: p.stevens at libero.it Current version is 6.6 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Template problem: macros to identify sender name and address
Hi On Thursday 2 October 2014 at 9:59:46 PM, in mid:4ler2atqqdqqu3m28jal7jtrbq83cbc...@4ax.com, Luca wrote: MFPA: %To = %ToName %ABToState Luca: Seems not to work ): the variable %TO only adds a recipient to the To: field, doesn't substitute the default value that's inevitably formed by the two fields Name email, and email uniquely identifies the AB entry to pick values from. That seems to me at a first attempt. But I'm going to try harder later. OK. I missed the quote marks:- %To = %ToName %ABToState And if the email address is stored in the State field without being surrounded by angle brackets you could add them here:- %To = %ToName %ABToState And the %To macro seems to append to the existing To header, rather than replacing it as the help file says. But %SETHEADER(header, text) does what it says on the tin:- %setHeader(To, %ToName %ABToState) %- -- Best regards MFPAmailto:2014-667rhzu3dc-lists-gro...@riseup.net Teamwork is essential - it allows you to blame someone else Using The Bat! v4.0.38 on Windows XP 5.1 Build 2600 Service Pack 3 Current version is 6.6 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Template problem: macros to identify sender name and address
MFPA: One simple suggestion would be just the one AB entry for each student, and list the username and password for all courses in the Memo field. An example AB entry might be:- Name: John Doe Email: john@domain.com Memo: Course: Course0 Username:Username0 Password:Password0 Course: Course1 Username:Username1 Password:Password1 Your quick template would now be:- %TONAME %ABtoMemo So the student would receive just one email that listed the usernames and passwords for all their courses. Yes, I was hoping to avoid that solution because I can't manage it automatically. I use Access to export a tab delimited file from the school database and feed it into The Bat address book, and I would need to manually merge any double entry by editing the memo field and deleting the double. Maybe I could build a new query to export a different type of address list, with memo fields already filled that way, but I guess it would need a lot of work (-: Anyway, thanx a lot for your input. -- Luca - e-mail: p.stevens at libero.it Current version is 6.1.8 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Template problem: macros to identify sender name and address
Maybe I could build a new query to export a different type of address list, with memo fields already filled that way, but I guess it would need a lot of work (-: I am coming in late on this one but how about address book groups for the different courses? Current version is 6.1.8 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Template problem: macros to identify sender name and address
Hi On Monday 29 September 2014 at 8:02:39 AM, in mid:5510139025.20140929030...@grunwalds.com, Rick wrote: Maybe I could build a new query to export a different type of address list, with memo fields already filled that way, but I guess it would need a lot of work (-: I am coming in late on this one but how about address book groups for the different courses? I wondered about that, but am not sure %ABtoPPP would search only in the AB group selected for the mass mailing. -- Best regards MFPAmailto:2014-667rhzu3dc-lists-gro...@riseup.net Hard work never killed anyone, but why take a risk? Using The Bat! v4.0.38 on Windows XP 5.1 Build 2600 Service Pack 3 Current version is 6.1.8 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Template problem: macros to identify sender name and address
Hi On Monday 29 September 2014 at 7:48:52 AM, in mid:9cvh2alt1ait4iq43sf9lbl13052rsp...@4ax.com, Luca wrote: Maybe I could build a new query to export a different type of address list, with memo fields already filled that way, but I guess it would need a lot of work (-: Can you alter the order of the fields exported by your Access Query so that the string TB! stores in the email address AB field is unique for each AB record, and the actual email address gets stored in a different AB field? Then %ABtoPPP would select the correct AB entry each time, so that you get the correct Username and Password for the course in the email body. And you would need to add a macro to substitute in the email address afterwards. For example, if you stored the email address in the State field, it might be something like:- %To = %ToName %ABToState Disclaimer: I have not tested this. -- Best regards MFPAmailto:2014-667rhzu3dc-lists-gro...@riseup.net Don't learn safety rules by accident... Using The Bat! v4.0.38 on Windows XP 5.1 Build 2600 Service Pack 3 Current version is 6.1.8 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Template problem: macros to identify sender name and address
MFPA: Hi On Monday 29 September 2014 at 8:02:39 AM, in mid:5510139025.20140929030...@grunwalds.com, Rick wrote: Maybe I could build a new query to export a different type of address list, with memo fields already filled that way, but I guess it would need a lot of work (-: I am coming in late on this one but how about address book groups for the different courses? I wondered about that, but am not sure %ABtoPPP would search only in the AB group selected for the mass mailing. Unfortunately not. Even if I select a single message for a new message using template action, the %ABtoPPP will select the first occurrence of PPP for the corresponding email address, in the whole set of address books. -- Luca - e-mail: p.stevens at libero.it Current version is 6.1.8 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Template problem: macros to identify sender name and address
MFPA: Can you alter the order of the fields exported by your Access Query so that the string TB! stores in the email address AB field is unique for each AB record, and the actual email address gets stored in a different AB field? Then %ABtoPPP would select the correct AB entry each time, so that you get the correct Username and Password for the course in the email body. And you would need to add a macro to substitute in the email address afterwards. For example, if you stored the email address in the State field, it might be something like:- %To = %ToName %ABToState Disclaimer: I have not tested this. That looks brilliant and promising a trick. I'll test it as soon as I can then report here. Thanx! -- Luca - e-mail: p.stevens at libero.it Current version is 6.1.8 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
Re: Template problem: macros to identify sender name and address
Hi On Sunday 28 September 2014 at 11:36:09 AM, in mid:mamf2admh27lk46j97tt54nbffs58em...@4ax.com, Luca wrote: In short: I guess I need a value for nnn in the ABnnnPPP macro to pick the whole To: header field of the message. The to value seems to pick only the email address, without the nick part. The help file entry you quoted says nnn determines the address used. You seem to have multiple AB entries with different display names but the *same* address. I would not expect the display name to be part of the information used to search the address book. Any help? Different solutions for the problem? I would be really grateful. One simple suggestion would be just the one AB entry for each student, and list the username and password for all courses in the Memo field. An example AB entry might be:- Name: John Doe Email: john@domain.com Memo: Course: Course0 Username:Username0 Password:Password0 Course: Course1 Username:Username1 Password:Password1 Your quick template would now be:- %TONAME %ABtoMemo So the student would receive just one email that listed the usernames and passwords for all their courses. -- Best regards MFPAmailto:2014-667rhzu3dc-lists-gro...@riseup.net Live your life as though every day it was your last. Using The Bat! v4.0.38 on Windows XP 5.1 Build 2600 Service Pack 3 Current version is 6.1.8 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html