Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom / Specilized Forms to enter data in Excel | Excel Worksheet Functions | |||
Can I use Access forms in Excel | Excel Discussion (Misc queries) | |||
Can I use Access forms in Excel? | Excel Discussion (Misc queries) | |||
How to access Excel forum through Outlook Express | Excel Discussion (Misc queries) | |||
Can I create custom forms to add data to a Excel Spreadsheet? How. | Excel Discussion (Misc queries) |