Sample code for 30+ languages & platforms
SQL Server Requires Chilkat v11.0.0+

Find and save an attachment and list inline images

See more Email Object Examples

Find an attachment by filename and media type, then save its decoded bytes to a path you choose. Enumerate inline resources separately to read their Content-IDs.

Chilkat SQL Server Downloads

SQL Server
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @iTmp1 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @sTmp1 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Assumes Chilkat is unlocked. See Global Unlock Sample.

    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_OAMethod @email, 'LoadEml', @success OUT, 'with-attachments.eml'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @email, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        RETURN
      END
    DECLARE @filename int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @filename OUT

    DECLARE @mediaType int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @mediaType OUT

    DECLARE @found int
    SELECT @found = 0
    DECLARE @i int
    SELECT @i = 0
    EXEC sp_OAGetProperty @email, 'NumAttachments', @iTmp0 OUT
    WHILE (@i < @iTmp0)
      BEGIN
        EXEC sp_OAMethod @email, 'GetAttachmentFilename', @sTmp0 OUT, @i
        EXEC sp_OAMethod @filename, 'SetString', @success OUT, @sTmp0
        EXEC sp_OAMethod @email, 'GetAttachmentContentType', @sTmp0 OUT, @i
        EXEC sp_OAMethod @mediaType, 'SetString', @success OUT, @sTmp0
        EXEC sp_OAMethod @filename, 'ContentsEqual', @iTmp0 OUT, 'agenda.csv', 0
        EXEC sp_OAMethod @mediaType, 'ContentsEqual', @iTmp1 OUT, 'text/csv', 0
        IF (@iTmp0 = 1) and (@iTmp1 = 1) and (@found = 0)
          BEGIN
            DECLARE @data int
            EXEC @hr = sp_OACreate 'Chilkat.BinData', @data OUT

            EXEC sp_OAMethod @email, 'GetAttachmentBd', @success OUT, @i, @data
            IF @success <> 1
              BEGIN
                EXEC sp_OAGetProperty @email, 'LastErrorText', @sTmp0 OUT
                PRINT @sTmp0
                EXEC @hr = sp_OADestroy @email
                EXEC @hr = sp_OADestroy @filename
                EXEC @hr = sp_OADestroy @mediaType
                EXEC @hr = sp_OADestroy @data
                RETURN
              END
            EXEC sp_OAMethod @data, 'WriteFile', @success OUT, 'received-agenda.csv'
            IF @success <> 1
              BEGIN

                PRINT 'Failed: data.WriteFile.'
                EXEC @hr = sp_OADestroy @email
                EXEC @hr = sp_OADestroy @filename
                EXEC @hr = sp_OADestroy @mediaType
                EXEC @hr = sp_OADestroy @data
                RETURN
              END

            EXEC sp_OAGetProperty @data, 'NumBytes', @iTmp0 OUT

            PRINT 'Saved attachment: ' + @iTmp0 + ' bytes.'
            SELECT @found = 1
          END
        SELECT @i = @i + 1
      END
    IF @found <> 1
      BEGIN

        PRINT 'No matching attachment.'
      END
    SELECT @i = 0
    EXEC sp_OAGetProperty @email, 'NumRelatedItems', @iTmp0 OUT
    WHILE (@i < @iTmp0)
      BEGIN

        EXEC sp_OAMethod @email, 'GetRelatedContentType', @sTmp0 OUT, @i

        EXEC sp_OAMethod @email, 'GetRelatedContentID', @sTmp1 OUT, @i
        PRINT 'Related: ' + @sTmp0 + '  Content-ID: ' + @sTmp1
        SELECT @i = @i + 1
      END

    EXEC @hr = sp_OADestroy @email
    EXEC @hr = sp_OADestroy @filename
    EXEC @hr = sp_OADestroy @mediaType
    EXEC @hr = sp_OADestroy @data


END
GO