A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Outlook E-mail Forms?



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old July 12th 07, 09:42 PM posted to microsoft.public.office.developer.automation,microsoft.public.outlook,microsoft.public.outlook.Program_VBA
Neil
external usenet poster
 
Posts: 43
Default Outlook E-mail Forms?

Does Outlook have an e-mail "form" or "template" where the body of an e-mail
can be created, and just certain fields can be filled in, as particular to
the recipient?

What I am needing to do is create such a form (if possible), open Outlook
through Automation, and then populate certain fields with the data, and then
send the e-mail (or leave open for the user).

We are using Office XP, but may go to Office 2007 soon.

Thanks!

Neil


  #2  
Old July 12th 07, 10:06 PM posted to microsoft.public.office.developer.automation,microsoft.public.outlook,microsoft.public.outlook.program_vba
Mary
external usenet poster
 
Posts: 328
Default Outlook E-mail Forms?

You can create boilerplate text by using Signatures and then just select the
one you want by choosing Insert, Signatures.

"Neil" wrote:

Does Outlook have an e-mail "form" or "template" where the body of an e-mail
can be created, and just certain fields can be filled in, as particular to
the recipient?

What I am needing to do is create such a form (if possible), open Outlook
through Automation, and then populate certain fields with the data, and then
send the e-mail (or leave open for the user).

We are using Office XP, but may go to Office 2007 soon.

Thanks!

Neil



  #3  
Old July 12th 07, 10:09 PM posted to microsoft.public.office.developer.automation,microsoft.public.outlook,microsoft.public.outlook.Program_VBA
Steven M (remove wax and invalid to reply)
external usenet poster
 
Posts: 5
Default Outlook E-mail Forms?

Je Thu, 12 Jul 2007 19:42:26 GMT, "Neil" skribis:

Does Outlook have an e-mail "form" or "template" where the body of an e-mail
can be created, and just certain fields can be filled in, as particular to
the recipient?

What I am needing to do is create such a form (if possible), open Outlook
through Automation, and then populate certain fields with the data, and then
send the e-mail (or leave open for the user).


I'm no expert, but I have been able to do this for my personal (not
company) installation of Outlook. One example: for spam complaints.
I click one button and a new email pops up, with a couple of addresses
already filled in and the words "Spam report:" in the subject line. I
do it without templates, just an Outlook macro.

It's a lot more difficult since Outlook doesn't have a macro recorder
(version 2000, anyway) like Word and Excel do, but I was able to find
some code online and modify it.



--
Steven M - lid
(remove wax and invalid to reply)

"It ain't what folks don't know that gets 'em in trouble; it's
knowing so many things that ain't so."
-- Kin Hubbard, American humorist, 19th cent.
  #4  
Old July 13th 07, 07:02 AM posted to microsoft.public.office.developer.automation,microsoft.public.outlook,microsoft.public.outlook.Program_VBA
Neil
external usenet poster
 
Posts: 43
Default Outlook E-mail Forms?

Thanks to both of you. I would be doing this from outside Outlook (through
Automation), and I would need to place text within the body of the e-mail,
e.g.:

Dear [ ]

Thank you for your [ ].

Regards,

[ ]

And so on.


"Steven M (remove wax and invalid to reply)"
wrote in message ...
Je Thu, 12 Jul 2007 19:42:26 GMT, "Neil" skribis:

Does Outlook have an e-mail "form" or "template" where the body of an
e-mail
can be created, and just certain fields can be filled in, as particular to
the recipient?

What I am needing to do is create such a form (if possible), open Outlook
through Automation, and then populate certain fields with the data, and
then
send the e-mail (or leave open for the user).


I'm no expert, but I have been able to do this for my personal (not
company) installation of Outlook. One example: for spam complaints.
I click one button and a new email pops up, with a couple of addresses
already filled in and the words "Spam report:" in the subject line. I
do it without templates, just an Outlook macro.

It's a lot more difficult since Outlook doesn't have a macro recorder
(version 2000, anyway) like Word and Excel do, but I was able to find
some code online and modify it.



--
Steven M - lid
(remove wax and invalid to reply)

"It ain't what folks don't know that gets 'em in trouble; it's
knowing so many things that ain't so."
-- Kin Hubbard, American humorist, 19th cent.



  #5  
Old July 13th 07, 08:59 AM posted to microsoft.public.office.developer.automation,microsoft.public.outlook,microsoft.public.outlook.Program_VBA
Steven M (remove wax and invalid to reply)
external usenet poster
 
Posts: 5
Default Outlook E-mail Forms?

I'm not sure about Automation, but here's what my VBA macro does to
generate my generic spam complaint. When I click a button, I get a
new email that includes the following in the body, plus a CC to the
FTC. It's followed here by the VBA code that creates it. Note that
the body text is assigned to the property "Body", and the CC address
is the "CC" property.

=== === === ===
The message below is unsolicited commercial email (spam).
It advertises the sale of prescription drugs.

Sending IP:

Web site promoted in spam:
Contact email listed in spam:

Hosted by:

Domain registration:

Original message, including full headers.
=== === === ===


Sub NewLart()

Dim myOLApp As New Outlook.Application
Dim myOLItem As Outlook.MailItem

Set myOLItem = myOLApp.CreateItem(olMailItem)
With myOLItem
.CC = "
.Subject = "Spam report: "
.Body = "The message below is unsolicited commercial email
(spam)." & Chr(13) & _
"It advertises the sale of prescription drugs." & Chr(13) & _
Chr(13) & _
"Sending IP:" & Chr(13) & _
Chr(13) & _
"Web site promoted in spam:" & Chr(13) & _
"Contact email listed in spam:" & Chr(13) & _
Chr(13) & _
"Hosted by:" & Chr(13) & Chr(13) & _
"Domain registration:" & Chr(13) & Chr(13) & _
"Original message, including full headers."
End With
myOLItem.Display

End Sub




Je Fri, 13 Jul 2007 05:02:59 GMT, "Neil" skribis:

Thanks to both of you. I would be doing this from outside Outlook (through
Automation), and I would need to place text within the body of the e-mail,
e.g.:

Dear [ ]

Thank you for your [ ].

Regards,

[ ]

And so on.


"Steven M (remove wax and invalid to reply)"
wrote in message ...
Je Thu, 12 Jul 2007 19:42:26 GMT, "Neil" skribis:

Does Outlook have an e-mail "form" or "template" where the body of an
e-mail
can be created, and just certain fields can be filled in, as particular to
the recipient?

What I am needing to do is create such a form (if possible), open Outlook
through Automation, and then populate certain fields with the data, and
then
send the e-mail (or leave open for the user).


I'm no expert, but I have been able to do this for my personal (not
company) installation of Outlook. One example: for spam complaints.
I click one button and a new email pops up, with a couple of addresses
already filled in and the words "Spam report:" in the subject line. I
do it without templates, just an Outlook macro.

It's a lot more difficult since Outlook doesn't have a macro recorder
(version 2000, anyway) like Word and Excel do, but I was able to find
some code online and modify it.




--
Steven M - lid
(remove wax and invalid to reply)

It is criminal to steal a purse, daring to steal a fortune,
a mark of greatness to steal a crown. The blame
diminishes as the guilt increases.
-- Johan Christoph Friedrich von Schiller
  #6  
Old July 17th 07, 04:21 AM posted to microsoft.public.office.developer.automation,microsoft.public.outlook,microsoft.public.outlook.Program_VBA
Neil
external usenet poster
 
Posts: 43
Default Outlook E-mail Forms?

Thanks. Yeah, that would work. But what I'm needing is something the user
can create (via a form or whatever) and apply formatting to, etc. Thanks for
your help.

Neil


"Steven M (remove wax and invalid to reply)"
wrote in message ...
I'm not sure about Automation, but here's what my VBA macro does to
generate my generic spam complaint. When I click a button, I get a
new email that includes the following in the body, plus a CC to the
FTC. It's followed here by the VBA code that creates it. Note that
the body text is assigned to the property "Body", and the CC address
is the "CC" property.

=== === === ===
The message below is unsolicited commercial email (spam).
It advertises the sale of prescription drugs.

Sending IP:

Web site promoted in spam:
Contact email listed in spam:

Hosted by:

Domain registration:

Original message, including full headers.
=== === === ===


Sub NewLart()

Dim myOLApp As New Outlook.Application
Dim myOLItem As Outlook.MailItem

Set myOLItem = myOLApp.CreateItem(olMailItem)
With myOLItem
.CC = "
.Subject = "Spam report: "
.Body = "The message below is unsolicited commercial email
(spam)." & Chr(13) & _
"It advertises the sale of prescription drugs." & Chr(13) & _
Chr(13) & _
"Sending IP:" & Chr(13) & _
Chr(13) & _
"Web site promoted in spam:" & Chr(13) & _
"Contact email listed in spam:" & Chr(13) & _
Chr(13) & _
"Hosted by:" & Chr(13) & Chr(13) & _
"Domain registration:" & Chr(13) & Chr(13) & _
"Original message, including full headers."
End With
myOLItem.Display

End Sub




Je Fri, 13 Jul 2007 05:02:59 GMT, "Neil" skribis:

Thanks to both of you. I would be doing this from outside Outlook (through
Automation), and I would need to place text within the body of the e-mail,
e.g.:

Dear [ ]

Thank you for your [ ].

Regards,

[ ]

And so on.


"Steven M (remove wax and invalid to reply)"

wrote in message ...
Je Thu, 12 Jul 2007 19:42:26 GMT, "Neil" skribis:

Does Outlook have an e-mail "form" or "template" where the body of an
e-mail
can be created, and just certain fields can be filled in, as particular
to
the recipient?

What I am needing to do is create such a form (if possible), open
Outlook
through Automation, and then populate certain fields with the data, and
then
send the e-mail (or leave open for the user).

I'm no expert, but I have been able to do this for my personal (not
company) installation of Outlook. One example: for spam complaints.
I click one button and a new email pops up, with a couple of addresses
already filled in and the words "Spam report:" in the subject line. I
do it without templates, just an Outlook macro.

It's a lot more difficult since Outlook doesn't have a macro recorder
(version 2000, anyway) like Word and Excel do, but I was able to find
some code online and modify it.




--
Steven M - lid
(remove wax and invalid to reply)

It is criminal to steal a purse, daring to steal a fortune,
a mark of greatness to steal a crown. The blame
diminishes as the guilt increases.
-- Johan Christoph Friedrich von Schiller



  #7  
Old July 13th 07, 01:30 PM posted to microsoft.public.office.developer.automation,microsoft.public.outlook.Program_VBA
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Outlook E-mail Forms?

[removing microsoft.public.outlook group]

In that case, you're not talking about published Outlook custom forms at all. There are several possible approaches, but they depend on how much code you want to write, your comfort level with writing HTML code, the Outlook version, whether this is something for your personal use or for wider distribution, and your tolerance for security prompts. Could you fill in some more details for us?

For the security prompt issue, see See http://www.outlookcode.com/article.aspx?ID=52 for your options with regard to the "object model guard" security in Outlook 2000 SP2 and later versions.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Neil" wrote in message . net...
Thanks to both of you. I would be doing this from outside Outlook (through
Automation), and I would need to place text within the body of the e-mail,
e.g.:

Dear [ ]

Thank you for your [ ].

Regards,

[ ]

And so on.


"Steven M (remove wax and invalid to reply)"
wrote in message ...
Je Thu, 12 Jul 2007 19:42:26 GMT, "Neil" skribis:

Does Outlook have an e-mail "form" or "template" where the body of an
e-mail
can be created, and just certain fields can be filled in, as particular to
the recipient?

What I am needing to do is create such a form (if possible), open Outlook
through Automation, and then populate certain fields with the data, and
then
send the e-mail (or leave open for the user).


I'm no expert, but I have been able to do this for my personal (not
company) installation of Outlook. One example: for spam complaints.
I click one button and a new email pops up, with a couple of addresses
already filled in and the words "Spam report:" in the subject line. I
do it without templates, just an Outlook macro.

It's a lot more difficult since Outlook doesn't have a macro recorder
(version 2000, anyway) like Word and Excel do, but I was able to find
some code online and modify it.


  #8  
Old July 17th 07, 04:26 AM posted to microsoft.public.office.developer.automation,microsoft.public.outlook.Program_VBA
Neil
external usenet poster
 
Posts: 43
Default Outlook E-mail Forms?

I'm looking for something that the user can create and apply formatting to,
but place fields or placeholders in the e-mail template or whatever, where
my code can use it to create an e-mail and fill in the data in the fields.
This would be similar to a Word doc that has "fields" or "bookmarks" in it
that can be replaced with data. (You might ask, why not just use Word, then?
The answer is, I could, but I'd prefer to use Outlook, as users are used to
sending e-mails from Outlook.)

This is something that might be set up by an administrator and then used by
various users. The e-mail does not need to be sent, just opened for the user
to send.

Version is Office 2003, with a possible upgrade to 2007.

Thanks,

Neil


"Sue Mosher [MVP-Outlook]" wrote in message
...
[removing microsoft.public.outlook group]

In that case, you're not talking about published Outlook custom forms at
all. There are several possible approaches, but they depend on how much code
you want to write, your comfort level with writing HTML code, the Outlook
version, whether this is something for your personal use or for wider
distribution, and your tolerance for security prompts. Could you fill in
some more details for us?

For the security prompt issue, see See
http://www.outlookcode.com/article.aspx?ID=52 for your options with regard
to the "object model guard" security in Outlook 2000 SP2 and later versions.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Neil" wrote in message
. net...
Thanks to both of you. I would be doing this from outside Outlook (through
Automation), and I would need to place text within the body of the e-mail,
e.g.:

Dear [ ]

Thank you for your [ ].

Regards,

[ ]

And so on.


"Steven M (remove wax and invalid to reply)"

wrote in message ...
Je Thu, 12 Jul 2007 19:42:26 GMT, "Neil" skribis:

Does Outlook have an e-mail "form" or "template" where the body of an
e-mail
can be created, and just certain fields can be filled in, as particular
to
the recipient?

What I am needing to do is create such a form (if possible), open Outlook
through Automation, and then populate certain fields with the data, and
then
send the e-mail (or leave open for the user).


I'm no expert, but I have been able to do this for my personal (not
company) installation of Outlook. One example: for spam complaints.
I click one button and a new email pops up, with a couple of addresses
already filled in and the words "Spam report:" in the subject line. I
do it without templates, just an Outlook macro.

It's a lot more difficult since Outlook doesn't have a macro recorder
(version 2000, anyway) like Word and Excel do, but I was able to find
some code online and modify it.



  #9  
Old July 17th 07, 02:11 PM posted to microsoft.public.office.developer.automation,microsoft.public.outlook.Program_VBA
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Outlook E-mail Forms?

There are several ways to do this, roughly in order from easy to hard:

1) Create an email message with blank spaces where you want the user to type, then save it as an .oft file. Invoke it with the Application.CreateItemFromTemplate method from the Outlook object model.

2) Create a Word template with the desired layout and fields and include a macro to display the "Office envelope" controls where the user can enter recipients and subject.

3) Provide your own interface where the user can enter the necessary data, then create an email message, either with one of the above types of templates or by building raw HTML, and then display it to the user for further modifcation.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Neil" wrote in message et...
I'm looking for something that the user can create and apply formatting to,
but place fields or placeholders in the e-mail template or whatever, where
my code can use it to create an e-mail and fill in the data in the fields.
This would be similar to a Word doc that has "fields" or "bookmarks" in it
that can be replaced with data. (You might ask, why not just use Word, then?
The answer is, I could, but I'd prefer to use Outlook, as users are used to
sending e-mails from Outlook.)

This is something that might be set up by an administrator and then used by
various users. The e-mail does not need to be sent, just opened for the user
to send.

Version is Office 2003, with a possible upgrade to 2007.

Thanks,

Neil


"Sue Mosher [MVP-Outlook]" wrote in message
...
[removing microsoft.public.outlook group]

In that case, you're not talking about published Outlook custom forms at
all. There are several possible approaches, but they depend on how much code
you want to write, your comfort level with writing HTML code, the Outlook
version, whether this is something for your personal use or for wider
distribution, and your tolerance for security prompts. Could you fill in
some more details for us?

For the security prompt issue, see See
http://www.outlookcode.com/article.aspx?ID=52 for your options with regard
to the "object model guard" security in Outlook 2000 SP2 and later versions.



"Neil" wrote in message
. net...
Thanks to both of you. I would be doing this from outside Outlook (through
Automation), and I would need to place text within the body of the e-mail,
e.g.:

Dear [ ]

Thank you for your [ ].

Regards,

[ ]

And so on.


"Steven M (remove wax and invalid to reply)"

wrote in message ...
Je Thu, 12 Jul 2007 19:42:26 GMT, "Neil" skribis:

Does Outlook have an e-mail "form" or "template" where the body of an
e-mail
can be created, and just certain fields can be filled in, as particular
to
the recipient?

What I am needing to do is create such a form (if possible), open Outlook
through Automation, and then populate certain fields with the data, and
then
send the e-mail (or leave open for the user).

I'm no expert, but I have been able to do this for my personal (not
company) installation of Outlook. One example: for spam complaints.
I click one button and a new email pops up, with a couple of addresses
already filled in and the words "Spam report:" in the subject line. I
do it without templates, just an Outlook macro.

It's a lot more difficult since Outlook doesn't have a macro recorder
(version 2000, anyway) like Word and Excel do, but I was able to find
some code online and modify it.



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook E-mail Forms? Neil Outlook - General Queries 5 July 17th 07 04:21 AM
when I open outlook forms (*.oft) it is appear as regular e-mail? Mohammad Matar Outlook - Using Forms 1 January 27th 07 01:42 PM
How to have custom mail forms integrated to Outlook? MeAgin Outlook - Using Forms 3 December 11th 06 01:22 PM
How do I mail merge personal outlook forms fields to Word Pete Outlook - Using Forms 1 December 6th 06 04:15 AM
Outlook 2003 - Forms Icon On toolbar doesn't list any forms Kim.in.Denver Outlook - Using Forms 8 July 28th 06 05:35 PM


All times are GMT +1. The time now is 08:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.