Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom / Specilized Forms to enter data in Excel Gaylen Excel Worksheet Functions 2 January 23rd 09 02:51 PM
Can I use Access forms in Excel Capbl Excel Discussion (Misc queries) 0 June 6th 06 03:25 PM
Can I use Access forms in Excel? Capbl Excel Discussion (Misc queries) 0 June 6th 06 03:23 PM
How to access Excel forum through Outlook Express Kenny Dee Excel Discussion (Misc queries) 6 December 28th 05 04:37 PM
Can I create custom forms to add data to a Excel Spreadsheet? How. TomassoP Excel Discussion (Misc queries) 1 January 25th 05 08:54 PM


All times are GMT +1. The time now is 05:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"