outlook training london - How do I create macros

Resolved · Low Priority · Version 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:

Sending on behalf of tip related to servers

If somebody gives you the correct access to there inbox then you should be able to send on behalf of that person. If it says that you do not have permissions then you would need to speak with the techie guys. There is a setting on all user accounts which gives you send on behalf of rights. Users would need to be added and thus solving the issue.

This is something that I came accross on a recent rollout.

View all Outlook hints and tips

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:

Sending on behalf of tip related to servers