Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
xp_sendmail help
- Thread starter annah
- Start date
The mail attachement is a string that contrains the path and filename of the file to attach.
Don't forget that the path and filename will be assessed from the server, So if you put an attachement as "C:\MyFiles\File1.txt" then the directory and file MUST exist on the server running SQLServer.
You will probably find the MAPI error is caused by not finding the file to attach.
Hope this helps,
Chris Dukes
Don't forget that the path and filename will be assessed from the server, So if you put an attachement as "C:\MyFiles\File1.txt" then the directory and file MUST exist on the server running SQLServer.
You will probably find the MAPI error is caused by not finding the file to attach.
Hope this helps,
Chris Dukes
- Status