Sending Customized Forms Externally

[Guest]

Hi-

I need some way of shipping people external to my agency at least the
contents of a customized form, even if I lose the formatting. The only
method I can think at present is to build a button to execute some sort of
macro or code onto a customized form that saves the form as text, and then
attaching that text to the e-mail that goes externally.

The goal of the form is notify residential providers that we need placement
for an especially troubled child, while supplying the providers with all the
steps, dates and decisions (and the full list of people involved in those
decisions) that have been completed to date by my agency's staff.

Thanks for your help and suggestions.

I use Outlook 2000, others have 2003.

 

[Sue Mosher [MVP-Outlook]]

You're on the right track. What you need to do is create a completely new message (Application.CreateItem), populate its Recipients collection, set its Subject and HTMLBody properties and send that message, not the custom form message. You should never send a custom form message externally.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Sue-

I'm totally inexperienced in this. Does my customized form have to be
published internally for this to work?

I do have someone who can help me with VBA code, but I better know the
quirks of Outlook...

 

[Sue Mosher [MVP-Outlook]]

Yes, if you want a custom Outlook form to run code, it must be published. Unpublished forms don't run code.

The programming language for code behind an Outlook form is VBScript, not VBA.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Sue-

Thanks again for your attention.

To create the e-mail that goes externally, do I create the e-mail from the
custom form in the act of sending or writing the custom form to internal
users, or do I run the code after the internal e-mail has been sent?

I'd like to create the external e-mail from within the process of sending
the internal custom e-mail, as it allows me to test user access to that
feature (only certain users will be allowed to send external e-mail). I'm
not in our main IS shop so I have very little flexibility as to what tools I
have available. Any ideas of what key words to use to search for examples of
code are greatly appreciated.

By the way, I've put your book on Outlook programming in the VBA
programmers' hands whose helping me over the next two days...

 

[Sue Mosher [MVP-Outlook]]

I'd do it in the Item_Send event handler of the custom form, calling Application.CreateItem to create the external message, then populating its properties and sending it.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers