Hello Terry,
Wednesday, February 18, 2004, 3:05:11 PM, Terry wrote:
T> I have written Access 2000 applications in Visual Basic for
T> Applications (VBA) that will send e-mail out using TB!, so I know it
T> can be done.
I've done it as well only somewhat different than you. See below.
... <snip>
T> TB! was only used as the mailing agent. Everything was done in Access
T> and then TB! was called during the program and sent the e-mail. There
T> was no need to import anything into TB!.
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?
What I've done in the past in Access was the following:
1 macro to run code
2 VB code which does the following:
(1) delete table
(2) run make table query
(3) export table in #2 to a CSV file
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
(1) email with Word document attached
(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.
Now this makes me sound like a spammer. <shrug> To be honest I used this
set up for applying for jobs. It sounds like you definitely skipped step
#3. How did you use TB as a "mailing agent" without using some form of
the editor or mass mail feature in TB?
--
Best Regards,
Greg Strong
WinAmp Playing:
Using The Bat! v2.04.2 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
