Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Outlook E-mail Forms? (http://www.outlookbanter.com/outlook-vba/52428-outlook-e-mail-forms.html)

Neil July 12th 07 09:42 PM

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



Mary July 12th 07 10:06 PM

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




Steven M (remove wax and invalid to reply) July 12th 07 10:09 PM

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.

Neil July 13th 07 07:02 AM

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.




Steven M (remove wax and invalid to reply) July 13th 07 08:59 AM

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

Sue Mosher [MVP-Outlook] July 13th 07 01:30 PM

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.



Neil July 17th 07 04:21 AM

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




Neil July 17th 07 04:26 AM

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.




Sue Mosher [MVP-Outlook] July 17th 07 02:11 PM

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.




Neil July 19th 07 01:18 PM

Outlook E-mail Forms?
 
Thanks.

"Sue Mosher [MVP-Outlook]" wrote in message
...
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.







All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com