Recent content by rat_1965

The names of the tables the users are using changes names? How is the database made and maybe a bit more background on what you are trying to do. I import data from an outside source every hour with a date time stamp, is it something like that? Maybe database replication might work?

The only other way I am aware of is to create a link to the other table and do an append query. Does that help?

First off thanks to Travis for getting me as far as I have. Now to the problem at hand for your perusal. I have code that picks up the records from a table, looping to get everything in the text of an email message. It will send the first email but any further attempts do absolutely diddly. I...

I don't mean to sound stupid but I am not too sure how to set the recordset to the table I want. The loop part I think I have down. Could I get a sample?

OK guru's here is what I am trying to do. I have a table with the data I want emailed. There is more than one record in the table and I would like to send out the email with all the data in the body of one email. I can't do this as an attachment as some people are using blackberries. The table...