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
Prev Previous Post   Next Post Next
  #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



 




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:41 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.