Auto E-Mail to preselected list.

**Jogier505** · 03-14-2010, 03:00 PM

I am still having problems getting the code to work. I keep getting a run time error 1004.
When I click the send button on the sheet the temp file is created and a screen comes up with the subject line but no addresses. If I click the send button on the new screen I am asked weather I want to end or debug. See attached file.

Thanks, Jim O

**Jogier505** · 03-16-2010, 02:24 PM

Bump.

Any thoughts?

Jim O

**Leith Ross** · 03-16-2010, 03:13 PM

Hello Jim,

Try using valid email addresses on the email sheet. Here is the error I got when I ran the code. Look familiar?

Run-time error '1004'

Unknown recipient found in the recipient list. Use a valid name and try again.

**Jogier505** · 03-16-2010, 03:39 PM

Leith,

That appears to be the problem. Sorry to be such a bother but with my very limited VBA knowledge I was sure it was something I had got wrong. Of course this presents a whole new range of issues but they are all on my end (making sure all addresses are correct).

Thanks to you and JBeaucaire for your time and effort with us beginners. I will mark this thread as SOLVED.

Jim O