Search results

Finished Product To download a sample of this along with 2 other email examples jump to http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=59311

The People of this Forum have been such a help, thought I would post a sample of the finished product. Many of you probably know how to do all of these in your sleep, but for those who don't, this may save the rest of you some time answering all those repeated email questions. Here are 3...

Thanks Again That was the help I needed. Thanks Jon K

Run into a Wall (Jon K can you look again) This is where I am on this so far. I could not get a query to run based on parameters I chose on a form from unbound combo boxes. ie. send email (yes/no), State (list of states), etc. Now the first task works. Jon K has got me this far. But now...

One Final Thought For anyone who is interested, the zip file above does work as Hay says. I just found a Security Setting in Outlook Express 6 under >Tools>Options>Security. You must Uncheck "Warn me when other applications try to send mail as me". Then in the VBA code set the line that...

Thanks Hay, That should do Mike

Hayley This is the Zip file I found. But when I click send email it requires me to click send for each email found in the query. I have set the line in the code from true to false and vise verse but it still requires me to manually send each email by clicking send. any suggetstions? (post...

Problem Solved Thanks Jon K, That's it to a 'T' ! Perfect.

The zip file did not post

Thanks to Mile-O-Phile, I have this great little form that will run a query that loops thru my table and gets every email address to paste in the BCC field of my email client (Outlook Express). So far So good! But I need the query to run based on parameters I chose on a form from unbound...

I am having trouble Building a Combo or List Box that will find a record based on a value that I select. I use the wizard in Access Office XP to build the Box. The values that the box is based on are the Partner ID and Last Name fields. the Combo or List boxt is Unbound. I set the Parter ID...

Greetings, I am a light weight database designer and vba code writer. I need some help. I have a form with a delete button. Every time I click the Delete button, I need the form to warn me before deleting the record from the table or related tables. Currently, when I click the delete...

I am missing error handlers for sure after creating a form that had several fields and just a delete button, i deleted all the records and was warned for every one. So in may master form, I am missing some error handlers. The random behavior I mentioned before must be due to the various...

I did that I remember deleting error handlers in the code, but I don't remember where they were... ie under which controls. where does this corrction go in the code Another problem I am a having with the delete control. it seems to be some what random. Even in my older copy of the...

Help - I'm Able to Delete Records without Warning What is happening? I use Access 2002 (xp) with a 2000 DB format. I have a form that has been woring well since it's creation about 10 months ago. It has a control button on it to delete the current record. If I clicked this button in the...

Now who would want to do that? Well, if you need to zip your package folder into an .exe and post it on the net, it's a must. Is there a way to get a Packaging Wizard Package with runtime files any smaller. My database is about 4 mb, but as a package the whole thing zipped with winzip is...

Seems to all check out This code is perfect. Simple yet effective. All tests on sample data check out. One final thought. Is there a limit to the number of email address that could be "sent" to Outlook Express. I have a total of about 400 in my database and I want to send to all of them at...

I think that's the ticket. I'm in the testing phase now. but it worked on my sample data. With Post above got out ahead of myself. Disregard. Sorry I did not disclose the Access Version earlier. Mike

Hangs on recordset now it's hanging on the second line of code Dim rs As ADODB.Recordet I set it up like this:

Compile Error Still not fully understanding the Loop idea. This is the code I attached to the cmdbutton, but when run i got compile error: User-defined type not defined on the first line. Clearly I'm not doing something right. ________________________________ Private Sub Email2_Click()...