ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Access Custom outlook Forms from within Excel VBA (https://www.excelbanter.com/excel-programming/278473-access-custom-outlook-forms-within-excel-vba.html)

phil neal

Access Custom outlook Forms from within Excel VBA
 
Hi all,

This is my fist post so please be gentle....

I am trying to set up a macro to send a custom outlook form (which has
already been created), I have sucesfully set up the part that sends
mail, but it only uses the default mail item (the items.add bit). how
can I set this to use the form ipm.note.summary the form is the same as
default note but gives a custom form when the recipient clicks reply.

Any Help appreciated!

Thanks

Phil

code is below

Dim OLF As Outlook.MAPIFolder, olMailItem As Outlook.MailItem
Dim ToContact As Outlook.Recipient
Set OLF = GetObject("", _

"Outlook.Application").GetNamespace("MAPI").GetDef aultFolder(olFolderInbox)

Set olMailItem = OLF.Items.Add ' creates a new e-mail message

With olMailItem
.Subject = "Subject" ' message subject



SNIP



.ReadReceiptRequested = True ' read confirmation
'.Save ' saves the message for later editing
.Send ' sends the e-mail message (puts it in the Outbox)
End With



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com