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