![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 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
|
|||
|
|||
![]()
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 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
|
|||
|
|||
![]()
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 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
|
|||
|
|||
![]()
[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 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
|
|||
|
|||
![]()
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 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
|
|||
|
|||
![]()
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 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 |
Display Modes | |
|
|
![]() |
||||
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 |