Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Outlook Training and help » outlook training london - How do I create macros

outlook training london - How do I create macros

ResolvedVersion Standard

Thu 15 Feb 2007, 09:53 Delegate Aura said...

Aura has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

How do I create macros

If I have to repeat phrases constantly in my emails, but is not exactly a template, is there any way to record macros containing this sentences so that I can insert them by using a short key or similar?

Thu 15 Feb 2007, 13:39 Trainer Garry said...

RE: How do I create macros

this is the code
sub mailmy()
Application.Dialogs(xlDialogSendMail).Show _
arg1:="Bookkeeper@Training.net", _
arg2:="Book Keeper"
End Sub
and to add a shortcut key goto tools macros and macros and select the option button

Mon 19 Feb 2007, 17:07 Delegate Aura said...

RE: How do I create macros

I don't quite get where to put this code. When I select the option visual basic editor, nothing happens.

Tue 20 Feb 2007, 14:01 Trainer Garry said...

RE: How do I create macros

It might be beneficial if you booked a VBA course or we will contact you
Thanks Garry

Outlook tip:

Right click options using the keyboard

If you are on message use SHIFT+F10, this gives the box which would appear when you right click a message.

View all Outlook hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

outlook training london - How do I create macros

How do I create macros

RE: How do I create macros

RE: How do I create macros

RE: How do I create macros

Outlook articles

Outlook tip:

Right click options using the keyboard