Hi Neil, On Wednesday, February 18, 2004 at 5:46 PM, Neil wrote: > New to this list so be gentle please...
Welcome! It's a great group, which I'm sure you'll find out. > I maintain a database of names, email addresses and order type and > quantity. > Now what I want to do is email everyone in the database at certain > times confirming what their order is, quantity and balance due. > All the data is held in an Excel spreadsheet. I'm a little confused. You say that you maintain a database, but then you talk about a spreadsheet. Do you have both or just a spreadsheet? <....snipped....> > Any ideas/macro example welcome! Why do you want to use TB! specifically for this task? How are you getting the client specific data to appear in the e-mail or is it a standard e-mail that is just bcc'ed to all the clients at a certain time? Sorry for the questions, but without knowing the format of your data, what you're trying to achieve, etc., it's hard to give you any specific suggestions. I have written Access 2000 applications in Visual Basic for Applications (VBA) that will send e-mail out using TB!, so I know it can be done. I've not tried it in Excel, however VBA is available in Excel so I would assume it could be done in Excel as well. TB! was only used as the mailing agent. Everything was done in Access and then TB! was called during the program and sent the e-mail. There was no need to import anything into TB!. Another consideration may be to do a mail merge in Word and then send the notices to your customers as attachments to an e-mail. You should be able to use VBA and/or macros within Word and Excel to do this. I haven't had a chance to play with the new Python plug-in yet, but there may be something that could be done with that. If you're not using a database already, you might want to consider it. Databases are more suited than spreadsheets are for tracking orders, customers, etc., and make it easier to accomplish precisely the type of thing that you are trying to do. You can do it with a spreadsheet, but it can grow unwieldy rather quickly and will not afford you the same flexibility as a database. Sorry I couldn't be of any more help. -- Regards, Terry Using The Bat! v2.01.3 on Windows XP 5.1 Build 2600 Service Pack 1 ________________________________________________ Current version is 2.02.3 CE | "Using TBUDL" information: http://www.silverstones.com/thebat/TBUDLInfo.html
