Recent content by uglydork

Thank you for your reply. I cant autonumber that high. I edited the registry to allow but it still isnt working

I have 2.5 million email addresses in a table. I dont want to mail merge all 2.5 million and send at once. I only want to blast 1,000 at a time. What is the best way to chunk this into smaller lists of 1,000 emails?

I spoke too soon. When I run the append, my original table has the same amount of records as before the append. It appears that when I ran the append to table 27 it didnt add the new records?

I believe this fixed it! Thank you so much for your help.

Thank you Mr.PaulO- I now have my tables linked. Great,that is something I needed anyway. So I will assume I build an append query and link all my common fields?

Thank you for the reply. I built this database last year and self taught. It has worked fine until I needed to update these records. I can write queries but I do not know how to program. I am smart enough to copy and paste code if I have needed it. I can not just drop the table on the table I...

1. My database has table 27. 2. Our company updates table 27 in an different database once a month not linked to my database. 3. My table 27 has some added fields such as dates and other items we use. 4. I need to update my table 27 once a month with the new data from my companies table 27...

I have dates that need to be 14 days from todays date. That way we know when to go into the field and cut someones electric for not paying their bill. (I work for a untility) So, I need todays date and a future date field so I can query cuts for the day. I can eliminate todays date if I have a...

I attached a picture in my previous post. I feel stupid as I build these things frequently (although basic) but I am having a senior moment.

Here is a pic

That is how I have it, but it is not working for me. I have never attemped to use this function in the past.

I added a todays date field in the table.

Users are adding phone numbers to the database. I would like to know when and what time the data was added as I have to send these numbers to an outbound dialer. It would be easier to schedule and make sure I dont continue to call the came people opver and over. Right now I only know the date...

Thank you Rich. That brings me back to my original question. When I import table 27 into my table 27 will it add all the records even though they are duplicates or will it overwite the records? The only thing that will have changed is KHW usage, all other fields will be the same.

The table names are both table 27. I have one in my database that reps use to input phone numbers that I use for an outbound calling campaign before we turn off electricity. The second table 27 is updated daily from the main system. I pull it once a week so I have proper KHW usage and I know...