Syntax for entering same statement as a reply

Status
Not open for further replies.
Z

zoididge1

Using Outlook 2007 on XP OS.

I'm new to Outlook macros and so tried to use my Word 2007 macro (see

following) as a standard reply to certain inquiries and it wont run. Once I

figure this one out, I'll be building about 10 other responses. Thanx for

any help.

sub MDLV_SST()

'

' MDLV_SST Macro

Selection.TypeParagraph

Selection.TypeText Text:="The major you have chosen, middle-level social

studies education, is currently in the curricular approval process. We

cannot guarantee that this major will be available by the time classes start

in fall 2010. As a result, we have placed you in secondary-level social

studies education. Please contact us with any questions or concerns."

End Sub
 
Selection in this usage is a Word object, not an Outlook object. Therefore,

what you need is a way to get from the open Outlook message to a

Word.Selection object. That mechanism is the WordEditor property of the

Outlook Inspector window, which returns a Word.Document object. The article

at

http://turtleflock-ol2007.spaces.live.com/blog/cns!C1013F1F9A99E3D8!579.entry

shows how to You need to change your code so that a Selection object is

derived from the actual Outlook item that you want to modify.

You can also use the new Quick Parts feature in Office 2007 to save and

insert boilerplate text. You can look up Quick Parts in Outlook 2007 Help;

also see

http://turtleflock-ol2007.spaces.live.com/blog/cns!C1013F1F9A99E3D8!158.entry

Sue Mosher

"zoididge1" <zoididge1> wrote in message

news:826BE819-A097-4265-8637-5F661E0D4104@microsoft.com...
> Using Outlook 2007 on XP OS.
> I'm new to Outlook macros and so tried to use my Word 2007 macro (see
> following) as a standard reply to certain inquiries and it wont run.
> Once I
> figure this one out, I'll be building about 10 other responses. Thanx for
> any help.

> sub MDLV_SST()
> '
> ' MDLV_SST Macro
> Selection.TypeParagraph
> Selection.TypeText Text:="The major you have chosen, middle-level
> social
> studies education, is currently in the curricular approval process. We
> cannot guarantee that this major will be available by the time classes
> start
> in fall 2010. As a result, we have placed you in secondary-level social
> studies education. Please contact us with any questions or concerns."

> End Sub
 
Thanx so much. Works for me.

"Sue Mosher [MVP]" wrote:


> Selection in this usage is a Word object, not an Outlook object. Therefore,
> what you need is a way to get from the open Outlook message to a
> Word.Selection object. That mechanism is the WordEditor property of the
> Outlook Inspector window, which returns a Word.Document object. The article
> at
> http://turtleflock-ol2007.spaces.live.com/blog/cns!C1013F1F9A99E3D8!579.entry
> shows how to You need to change your code so that a Selection object is
> derived from the actual Outlook item that you want to modify.

> You can also use the new Quick Parts feature in Office 2007 to save and
> insert boilerplate text. You can look up Quick Parts in Outlook 2007 Help;
> also see
> http://turtleflock-ol2007.spaces.live.com/blog/cns!C1013F1F9A99E3D8!158.entry
> > Sue Mosher
> > >

> "zoididge1" <zoididge1> wrote in message
> news:826BE819-A097-4265-8637-5F661E0D4104@microsoft.com...
> > Using Outlook 2007 on XP OS.
> > I'm new to Outlook macros and so tried to use my Word 2007 macro (see
> > following) as a standard reply to certain inquiries and it wont run.
> > Once I
> > figure this one out, I'll be building about 10 other responses. Thanx for
> > any help.
> > sub MDLV_SST()
> > '
> > ' MDLV_SST Macro
> > Selection.TypeParagraph
> > Selection.TypeText Text:="The major you have chosen, middle-level
> > social
> > studies education, is currently in the curricular approval process. We
> > cannot guarantee that this major will be available by the time classes
> > start
> > in fall 2010. As a result, we have placed you in secondary-level social
> > studies education. Please contact us with any questions or concerns."
> > End Sub

>
 
Status
Not open for further replies.
< Importing Contacts Does Not Use Defined Custom Form in Outlook 2007 | Outlook-Changing default reply format to HTML >
Similar threads
Thread starter Title Forum Replies Date
Wotme Syntax for user defined field in VBA Using Outlook 1
H Outlook 2007 SQL syntax to filter views of tasks and todo items Outlook VBA and Custom Forms 1
J syntax Outlook VBA and Custom Forms 1
S Outlook 2021 Can you make emails from 3 word domains "safe" by entering top 2 word domain into Safe List in Outlook? Using Outlook 1
M How to setup outlook after importing old account information - Entering email account info creates with "(1)" after the account! Using Outlook 1
O Calendar - Location: what happens when using my own way of entering locations Using Outlook 1
S Outlook 2007: Address Cards allow entering text! Why? Using Outlook 3
L Entering dates in Contacts and Calendar Using Outlook 4
A OL13 Calendar, won't allow entering 2 appointments consecutively Using Outlook 4
J Entering Contacts at Same Company Using Outlook 1
W Go to search field when entering a contact folder? Using Outlook 2
R Outlook 2021 Having problem setting up outlook 2021 with windows 11. I have 3 gmail accounts and I want the 3 gmail, emails to merge into the same outlook input. Using Outlook.com accounts in Outlook 0
E Outlook - eliminate same adresses from to, and bc line Outlook VBA and Custom Forms 0
O Same email address, same person, names in so many ways Using Outlook 4
B Outlook 2016 Unable to view images or logos on the outlook 2016 emails the same html code works well when i use outlook 2010 Using Outlook 0
M Outlook on 3 Computers Shows Different Total Items on Same Account Using Outlook 3
A Two Inboxes, Same Email? Using Outlook 3
R Disable conversation thread from replying of recipients in the same subject. Please help Using Outlook 0
jChambler iCloud folders in Outlook are not the same as on iCloud Using Outlook 6
glnz How set up new IMAP on Outlook-Office 365 and merge in pst from Outlook 2003 for same two email accounts? Using Outlook 5
M Same file "stuck" on top of file list in "Attach File" drop down Using Outlook 4
X Unable to send an email from one account to another on same PC Using Outlook 2
P Desktop doesn't index Outlook IMAP files, laptop Outlook does index those same IMAP files Using Outlook 2
N Move emails of same conversation to same subfolder Using Outlook 6
S Received mail as part of DL, need to auto-CC the same when replying Outlook VBA and Custom Forms 5
I get count of all emails with same conversation ID Outlook VBA and Custom Forms 2
R Shortcut for attaching the same file repeatedly Using Outlook 6
M warning for too many appointments on a same day in Outlook Using Outlook 1
A saving attachement to folder named the same as rule name Outlook VBA and Custom Forms 0
M Ensure the same inbox view across multiple outlook instances Using Outlook.com accounts in Outlook 7
L set task reminder date to same as start date (without affecting due date) Using Outlook 0
M Why delivery receipt size is same than sent email size or even larger? Using Outlook 1
C How to copy same text header to multiple emails with custom text column Using Outlook 10
D Calendar - color coded items are now the same color Using Outlook 2
K Outlook 2010 - Set the category based on category of other emails in same conversatio Using Outlook 20
B Mail on both laptop and mobile at same time Using Outlook 2
P Outlook Macro keeps running for the same messagage Using Outlook 2
M Can't open same msg file more than once at the same time in Outlook 2010 Using Outlook 7
L Delete code and commandbutton at the same time. Using Outlook 1
njs27 Start date of occurrence same as PatternStartDate Outlook VBA and Custom Forms 6
G How to let data in an account user defined field appear in the same field all related opportunities BCM (Business Contact Manager) 1
L IMAP and POP email in same Outlook system Using Outlook 1
A Use same BCM data in 2 offices BCM (Business Contact Manager) 3
A After receiving the same email 3 times, Outlook starts sending it to junk Using Outlook 1
K Help! I selected every contact and mistakenly made them all the same category Using Outlook 1
S Searching contacts across GAL and local address book at same time Using Outlook 1
D Move email to same folder as the rest of the conversation Using Outlook 1
J How to create fields that will use the same value on different record types BCM (Business Contact Manager) 2
R View two Inboxfolders at the same time in split creen Using Outlook 1
J How to Reply or Forward a message and Archive it in same step? Using Outlook 0

Similar threads

Back
Top