Thanks for the replies. Think I might have confused the issue by saying database. What I actually meant was that I have a spreadsheet of info - held in Excel.
(I don't have any experience of Access - last database I used was RBase! circa 1990) Now the bit I was using was as Greg described:- >>3 import CSV into TB AB group >> Note: The import was no hassle when you include field names in the >> first row that are the same as the field names in TB's import >> function. IOW just hit OK. >>4 Run QT in TB from AB group to create email in Outbox >> (2) email with all info in text email and NO attachment >> Note: In #2 I used the AB as a database to hold info for the >> fields used in my QT. (I note the useful tip about including field names in the CSV) Basically creating a template in TB and substituting variable names for the person specific email (therefore not a Bcc) so for example the spreadsheet would read:- Name, email, quantity, item, balance John Smith, [EMAIL PROTECTED], 5, widgets, �4.50 Paul Smith, [EMAIL PROTECTED], 3, plugs, �2.30 Then create a template so that the emails would read:- Email to %email% Dear %Name%, Your order for %quantity% %Item% has been despatched and the balance of your order is %balance% Note: I am using %xxx% to represent the value from the spreadsheet. So apart from import CSV into TB AB group then Run QT in TB from AB group to create email in Outbox there is no other way?? Neil Wednesday, February 18, 2004, 11:25:43 PM, you wrote: T> Hi Greg, T> <...snipped....> >> This may be over my head, but how did you send an email without >> importing anything into TB? Would you be able to provide more >> information here either on or off list? T> Use DoCmd.SendObject. Google will get you lots of info on it. I'll be T> happy to send you my code off list if you'd like it, although I don't T> know how much sense it will make. :) It's a routine I did for sending T> a daily e-mail to different people, all of whom wanted different T> reports in different formats as attachments. T> <....snipped procedure steps....> T> I skipped all your steps. The code did everything. I used the code T> with TB! 1.63r. It was never tested with TB! 2+, although I have no T> reason to think it wouldn't work. The code was assigned to a button T> on the startup form. The database operator pressed the form and that T> was it. T> Feel free to contact me off list if you need more info. -- Best regards, Neil mailto:[EMAIL PROTECTED] ________________________________________________ Current version is 2.02.3 CE | "Using TBUDL" information: http://www.silverstones.com/thebat/TBUDLInfo.html
