It is possible to send metting invitation by sp_sendmail?
I found out, that metting invitation is special e-mail, which have alternative view.
Please help...
Its possible use sp_OAMethod for this?
sp_OAMethod solved:
- files
IF @filename1 IS NOT NULL
EXEC @hr = sp_OAMethod @iMsg, 'AddAttachment', @iRtn Out, @filename1
- embeded pictures
DECLARE @bp INT
IF @imagename1 IS NOT NULL AND @imagecid1 IS NOT NULL
BEGIN
EXEC @hr = sp_OAMethod @iMsg, 'AddRelatedBodyPart', @bp out, @imagename1, @imagecid1, '1'
EXEC @hr = sp_OASetProperty @bp, 'Fields.Item("urn:schemas:mailheader:Content-ID").Value', @imagecid1
EXEC @hr = sp_OAMethod @bp, 'Fields.Update', null
END