PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook VBA Programming Help wanted with project

Reply

Help wanted with project

 
Thread Tools Rating: Thread Rating: 20 votes, 4.90 average.
Old 05-08-2004, 05:38 PM   #1
Parl
Guest
 
Posts: n/a
Default Help wanted with project


Looking to do following;
1. A button on the toolbar called "SEND SMS",which when clicked
automatically opens up an email compose window with the following
characteristics;

i) The "To:" is automatically populated with a specified internal email
address

ii) The email compose box overrides user settings and is automatically set
to "plain text"

iii) All automatically inserted signatures are removed from the body of the
email compose window

iv) If possible the user can not enter anything more into the "body" of the
email after the character count hits 300 characters

v) ..... plus other things if poss

Hoping to find someone (pref UK) to helpme with this project

Parl


  Reply With Quote
Old 06-08-2004, 12:11 AM   #2
=?Utf-8?B?S2VQYUhh?=
Guest
 
Posts: n/a
Default RE: Help wanted with project

This short macro will accomplish 1, 2, and 3:

Sub TestMacro9()
Dim olApp As Outlook.Application
Dim objMail As Outlook.MailItem
Set olApp = Outlook.Application
Set objMail = olApp.CreateItem(olMailItem)
With objMail
.Body = ""
.To = "username@domain.com"
.BodyFormat = olFormatPlain
.Display
End With
End Sub

Press Alt+F11 in Outlook to open the VB Editor. Paste this code in there. Close VB Editor window. Now in Tools, Customize, this macro can be dragged up onto the toolbar as a button.

"Parl" wrote:

> Looking to do following;
> 1. A button on the toolbar called "SEND SMS",which when clicked
> automatically opens up an email compose window with the following
> characteristics;
>
> i) The "To:" is automatically populated with a specified internal email
> address
>
> ii) The email compose box overrides user settings and is automatically set
> to "plain text"
>
> iii) All automatically inserted signatures are removed from the body of the
> email compose window
>
> iv) If possible the user can not enter anything more into the "body" of the
> email after the character count hits 300 characters
>
> v) ..... plus other things if poss
>
> Hoping to find someone (pref UK) to helpme with this project
>
> Parl
>
>
>

  Reply With Quote
Old 10-08-2004, 05:15 PM   #3
Parl
Guest
 
Posts: n/a
Default Re: Help wanted with project

Thanks

"KePaHa" <KePaHa@discussions.microsoft.com> wrote in message
news:27F1BB75-9114-4D22-BCF5-EB7BF854F61A@microsoft.com...
> This short macro will accomplish 1, 2, and 3:
>
> Sub TestMacro9()
> Dim olApp As Outlook.Application
> Dim objMail As Outlook.MailItem
> Set olApp = Outlook.Application
> Set objMail = olApp.CreateItem(olMailItem)
> With objMail
> .Body = ""
> .To = "username@domain.com"
> .BodyFormat = olFormatPlain
> .Display
> End With
> End Sub
>
> Press Alt+F11 in Outlook to open the VB Editor. Paste this code in there.

Close VB Editor window. Now in Tools, Customize, this macro can be dragged
up onto the toolbar as a button.
>
> "Parl" wrote:
>
> > Looking to do following;
> > 1. A button on the toolbar called "SEND SMS",which when clicked
> > automatically opens up an email compose window with the following
> > characteristics;
> >
> > i) The "To:" is automatically populated with a specified internal email
> > address
> >
> > ii) The email compose box overrides user settings and is automatically

set
> > to "plain text"
> >
> > iii) All automatically inserted signatures are removed from the body of

the
> > email compose window
> >
> > iv) If possible the user can not enter anything more into the "body" of

the
> > email after the character count hits 300 characters
> >
> > v) ..... plus other things if poss
> >
> > Hoping to find someone (pref UK) to helpme with this project
> >
> > Parl
> >
> >
> >



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

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