outlook training london - How do I create macros

The UK's most regular instructor-led training courses.
Training information: outlook training london · Outlook courses london · Microsoft outlook training

Resolved · Low Priority · Version Standard

How do I create macros

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

by - delegate Aura [2 posts] (2007 Feb 15 Thu, 09:53) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Outlook Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 7 Tue	Bloomsbury	7	book now	£203	£230
2003	2008 Dec 12 Fri	Bloomsbury	6	book now	£110	£224
2003	2009 Feb 3 Tue	Bloomsbury	8	book now	£75	£224
2003	2009 Apr 15 Wed	Bloomsbury	8	book now	£75	£224
2003	2009 Jun 10 Wed	Bloomsbury	8	book now	£75	£224
2003	2009 Aug 12 Wed	Bloomsbury	8	book now	£75	£224

RE: How do I create macros

by - trainer Garry gold contributer [188 posts] (2007 Feb 15 Thu, 13:39) Reply

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

RE: How do I create macros

by - delegate Aura [2 posts] (2007 Feb 19 Mon, 17:07) Reply

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

RE: How do I create macros

by - trainer Garry gold contributer [188 posts] (2007 Feb 20 Tue, 14:01) Reply

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

· Microsoft Outlook Cheat sheet: Tips & Shortcuts