Search results for query: *

Thanks, I'll geive that a try. I assume that any SP that have xp_startmail and xp_stopmail should be removed then.

More details. SQL Mail is enabled with a profile. The Agent starts on boot. I have SP_Readmail that runs every 10 min to get mail and place it into a table. This is what generates the logs referenced before. I think you helped me get this working some time ago:-) ++++++CODE...

Is there any way to stop it from logging? I run this every 10 min. So the log file gets blasted. THX

Hi, My mail services work fine but I get these errors every time xp_startmail runs. IT is an informational error. Any reason why? Error: 1073759806, Severity: 1, State: 0 Starting SQL Mail session... Error: 1073759778, Severity: 1, State: 0 SQL Mail session started. Thanks, LAM2

HI, I need to add the currentusers Department properity value from the "Global Address list" to a custom field MyDepartment on an outlook form (2000 & 2002). I can extract the user’s name and user’s manager, but not the department. Is this possible at all? Thanks in advance. LAM2

Thanks anyway all, I did it. I've included below incase anyone else needs this info. Set myNameSpace = Application.GetNameSpace("MAPI") Set myobject = Recipients.add(myNameSpace.CurrentUser.Name) Set MyOBJ1 = myobject.AddressEntry.Manager

HI, I need to add the currentusers Department to a custom field on an outlook form (2000 & 2002). This data resides in the users contact information in Active directory on W2K &E2K Domain. I can extract the user’s name and user’s manager, but not the department. Thanks in advance. LAM2

Since there is no help here on this topic can anyone direct me to get help? Thanks LAM2

I have an Outlook (2000 and XP) IPM.note form that I need to insert the user's Manager email address in the TO: (recipient) field when the form is opened. We are using Exchange 2000 with Active Directory. Thanks, LAM2

Great! I've got it working now! Thanks for your Help and Direction! :->

Terry, It works for one email fine now. How do I get it to loop through all email and only process the matching subject. (I tryed but I'm lost now) :-)

Thanks Terry L. Broadbent This code doen't put data into my tables. It does read the messages and deletes them. There are no errors that I can find. What's missing? SET @sql='Insert My_DB.dbo.Table1 (Col1, Col2) Values (' + @msg + ')' Does the Col1, and Col2 have to be the name of the actual...

Thanks in advance :-) I need to create new records based on emails received in SQL Mail. My server is set up for mail and operating fine. I have only needed to send mail so far. I've only found how to read mail and respond to it, but not how to write data to a table from contents. I need to...

PitBrain!!!!! Thanks, Thanks, and more Thanks, All is well in DBA Land. I was able to glean from your code what I needed!

How would you build the trigger statement for this to work. I haven't been able to.

Thanks, I've been able to do up to that. I need the second part. "and email the column (tn) and (complete) values for the row."

HI all, I need to create a trigger that will email user@domain.com after insert update or delete on the column (complete) on table (mytable) and email the column (tn) and (complete) values for the row. I'm not finding much help on this subject. Thanks, Len