I really, really appreciate everyones help on this. It is amazing how many of you and how much you are willing to help.

I am still stuck on...

I am sure I can figure out how to do a stored procedure, but it is not something that comes naturally to me.

Yes, I put the entire script I posted...

I need to sort out somethat that I am probably taking too literally. Here is my step 1 with the addition of your script. Does your script go...

You guys are almost done with me. I believe I have it working with one exception.

I created 2 steps

Step - 1 (create/output to text file)

select RM00101.CUSTNAME,DOCNUMBR,docamnt,curtrxam,SOP30200.DOCDATE,RM00101.SLPRSNID

from rm20101,rm00101,SOP30200 where rm00101.CUSTNMBR=rm20101.CUSTNMBR...

OK. Here is my current script. How do I not incorporate my query from the accounting db to get my 90 day invoices.

The email goes through until I...

You nailed it. Thank you!

The turkey who published this gave the minimum parameters, but left off the server name: http://sqldev.net/xp/xpsmtp.htm#Installation

(I hope none of you were that turkey. ...

This is killing me! Sorry for being so helpless.

I downloaded xp_smtp_sendmail and got it registered.

I ran this in query analyzer.

declare @rc int

exec @rc = master.dbo.xp_smtp_sendmail

@FROM...

Still trying with this thing. Not sure if I am taking the right direction. I have attempted to use the XP_Smtp_sendmail command. I pulled up an example...

I forget some key information. We are using Pop3, not Exchange. Does that make a difference?

Terry, Thank you very much! I think I am on my way to having this solved, but still am having some issues. I changed your script to...