SQL Server

Set the Reply-To Address of an Email

Demonstrates the Chilkat Email.ReplyTo property, which sets the MIME Reply-To header. This header automatically defaults to the From address, so you only set it when replies should go to a different address. There is usually a single Reply-To address, but you can supply a comma-separated list for several. Setting this changes only the Reply-To header — it does not change the SMTP envelope sender or the visible From header.

Background: When you hit "Reply," most mail clients address the response to the message's Reply-To header if present, otherwise to From. This is useful when the sending address is not the right destination for responses — for example, a newsletter sent from noreply@ but with Reply-To pointing at a monitored support inbox, or a message sent on someone's behalf that should be answered to a different person.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    --  Demonstrates the Email.ReplyTo property, which sets the Reply-To header field.
    --  Reply-To defaults to the From address, so you only set this when replies should
    --  go somewhere different.

    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @email, 'From', 'sales@example.com'

    --  Replies should be directed to a different address than the From address.
    EXEC sp_OASetProperty @email, 'ReplyTo', 'support@example.com'


    EXEC sp_OAGetProperty @email, 'ReplyTo', @sTmp0 OUT
    PRINT 'ReplyTo = ' + @sTmp0

    --  For multiple reply addresses, use a comma-separated list.
    EXEC sp_OASetProperty @email, 'ReplyTo', 'support@example.com, help@example.com'

    EXEC sp_OAGetProperty @email, 'ReplyTo', @sTmp0 OUT
    PRINT 'ReplyTo = ' + @sTmp0

    EXEC @hr = sp_OADestroy @email


END
GO