Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Create macro to insert signature into email... (http://www.outlookbanter.com/outlook-vba/69559-create-macro-insert-signature-into.html)

Fuel451 April 1st 08 01:35 AM

Create macro to insert signature into email...
 
I need to create a macro that will allow a user to use CTRL + a key to
insert their signature into their new email. I've viewed and tried some of
the sample codes and links, but I'm not able get anything to work.

Could someone provide a working solition or a link to information that might
resolve the issue?

Thank you

Sue Mosher [MVP-Outlook] April 1st 08 02:46 AM

Create macro to insert signature into email...
 
In what version of Outlook? If pre-Outlook 2007, with Word or the built-in Outlook editor?

What have you tried and what specifically didn't work?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Fuel451" wrote in message ...
I need to create a macro that will allow a user to use CTRL + a key to
insert their signature into their new email. I've viewed and tried some of
the sample codes and links, but I'm not able get anything to work.

Could someone provide a working solition or a link to information that might
resolve the issue?

Thank you


Fuel451 April 1st 08 03:39 AM

Create macro to insert signature into email...
 
Currently running Outlook 2003 on most workstations. This one in particular
is running version 2003 and I'm trying to use Outlook Editor. I've also
tried recording a macro with Word, but it doesn't seem to do anything when I
run the macro.


"Sue Mosher [MVP-Outlook]" wrote:

In what version of Outlook? If pre-Outlook 2007, with Word or the built-in Outlook editor?

What have you tried and what specifically didn't work?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Fuel451" wrote in message ...
I need to create a macro that will allow a user to use CTRL + a key to
insert their signature into their new email. I've viewed and tried some of
the sample codes and links, but I'm not able get anything to work.

Could someone provide a working solition or a link to information that might
resolve the issue?

Thank you



Sue Mosher [MVP-Outlook] April 1st 08 04:55 AM

Create macro to insert signature into email...
 
The sample at http://www.outlookcode.com/codedetail.aspx?id=615 should work fine with the built-in editor to insert a previously stored signature.

Note that using Ctrl+ key shortcuts isn't an option in Outlook. The closest solution is putting a command on the toolbar to run a macro and assign an Alt+ accelerator by putting a & in the command's caption.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Fuel451" wrote in message ...
Currently running Outlook 2003 on most workstations. This one in particular
is running version 2003 and I'm trying to use Outlook Editor. I've also
tried recording a macro with Word, but it doesn't seem to do anything when I
run the macro.


"Sue Mosher [MVP-Outlook]" wrote:

In what version of Outlook? If pre-Outlook 2007, with Word or the built-in Outlook editor?

What have you tried and what specifically didn't work?

"Fuel451" wrote in message ...
I need to create a macro that will allow a user to use CTRL + a key to
insert their signature into their new email. I've viewed and tried some of
the sample codes and links, but I'm not able get anything to work.

Could someone provide a working solition or a link to information that might
resolve the issue?

Thank you



Fuel451 April 1st 08 02:21 PM

Create macro to insert signature into email...
 
I must have the process wrong, because the macro does not show up after I
save it. Here's the process...

- tools, macro, macros
- insert macro name, click create
- paste the code in and save it
- when I go to tools customize, macros there's no macro listed
- when I go to the macros window, there's no macro listed

If I try to create a new macro, it brings up the editor and the code from
the previous macro and starts a new page.

"Sue Mosher [MVP-Outlook]" wrote:

The sample at http://www.outlookcode.com/codedetail.aspx?id=615 should work fine with the built-in editor to insert a previously stored signature.

Note that using Ctrl+ key shortcuts isn't an option in Outlook. The closest solution is putting a command on the toolbar to run a macro and assign an Alt+ accelerator by putting a & in the command's caption.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Fuel451" wrote in message ...
Currently running Outlook 2003 on most workstations. This one in particular
is running version 2003 and I'm trying to use Outlook Editor. I've also
tried recording a macro with Word, but it doesn't seem to do anything when I
run the macro.


"Sue Mosher [MVP-Outlook]" wrote:

In what version of Outlook? If pre-Outlook 2007, with Word or the built-in Outlook editor?

What have you tried and what specifically didn't work?

"Fuel451" wrote in message ...
I need to create a macro that will allow a user to use CTRL + a key to
insert their signature into their new email. I've viewed and tried some of
the sample codes and links, but I'm not able get anything to work.

Could someone provide a working solition or a link to information that might
resolve the issue?

Thank you



Sue Mosher [MVP-Outlook] April 1st 08 04:49 PM

Create macro to insert signature into email...
 
What does your macro look like? The sample is not a macro, but a subroutine that can be called by a macro, which would need to pass the name of the signature to the InsertSig procedure.

What code module did you create it in? (HINT: Use Alt+F11 to open the Outlook VBA directly.)
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Fuel451" wrote in message ...
I must have the process wrong, because the macro does not show up after I
save it. Here's the process...

- tools, macro, macros
- insert macro name, click create
- paste the code in and save it
- when I go to tools customize, macros there's no macro listed
- when I go to the macros window, there's no macro listed

If I try to create a new macro, it brings up the editor and the code from
the previous macro and starts a new page.

"Sue Mosher [MVP-Outlook]" wrote:

The sample at http://www.outlookcode.com/codedetail.aspx?id=615 should work fine with the built-in editor to insert a previously stored signature.

Note that using Ctrl+ key shortcuts isn't an option in Outlook. The closest solution is putting a command on the toolbar to run a macro and assign an Alt+ accelerator by putting a & in the command's caption.



"Fuel451" wrote in message ...
Currently running Outlook 2003 on most workstations. This one in particular
is running version 2003 and I'm trying to use Outlook Editor. I've also
tried recording a macro with Word, but it doesn't seem to do anything when I
run the macro.


"Sue Mosher [MVP-Outlook]" wrote:

In what version of Outlook? If pre-Outlook 2007, with Word or the built-in Outlook editor?

What have you tried and what specifically didn't work?

"Fuel451" wrote in message ...
I need to create a macro that will allow a user to use CTRL + a key to
insert their signature into their new email. I've viewed and tried some of
the sample codes and links, but I'm not able get anything to work.

Could someone provide a working solition or a link to information that might
resolve the issue?

Thank you



driko lane June 12th 08 05:32 PM

Create Auto Refrence Number for outgoing message inoutlook 2007
 
Hello all

I am trying to create a Auto reffrence number for each outgoing message i send from my outllok 2007. like so

Msg.No: 2333 Date: 2-12-1990 Time: 12:23 pm Jake

explanation
msg no -- is the message number itself
date -- is the date when themessage created
time --- is the time when themessage created
jake -- is the person who created / compose the message


i tried this tutorial http://www.outlookcode.com/codedetail.aspx?id=1660

but unfortunately, i failed..nothing cames up and shoed up..i dont have any knowlegde with macro tough...

can someone help me doing the above tutorial step-by-step?

thanks and appreciate your inputs...


Sue Mosher [MVP-Outlook] June 12th 08 06:00 PM

Create Auto Refrence Number for outgoing message in outlook 2007
 
That's not a tutorial; it's a code sample. It assumes that you know the basics of adding code to the Outlook VBA environment, as described at http://outlookcode.com/article.aspx?id=49

If you didn't understand part of the code sample or if part of the code did not run as expected, post a comment directly on that sample with details of the problem(s) you've encountered. The author also posted his blog address as a way of inviting comments and questions.

Other methods you can use:

1) Get the last number used in a folder. Listing 15.8 in my latest book, Microsoft Outlook 2007 Programming, demonstrates this. The code is usable in earlier versions and is available at http://outlookcode.com/member/book.aspx.

2) Use an Excel worksheet that contains VBA code to increment the number. See http://www.microsoft.com/office/comm...a-1324e136ff3a

You could also use a text file to hold the number or, if this is for your personal use, an Outlook item.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


driko lane wrote in message ...
Hello all

I am trying to create a Auto reffrence number for each outgoing message i send from my outllok 2007. like so

Msg.No: 2333 Date: 2-12-1990 Time: 12:23 pm Jake

explanation
msg no -- is the message number itself
date -- is the date when themessage created
time --- is the time when themessage created
jake -- is the person who created / compose the message


i tried this tutorial http://www.outlookcode.com/codedetail.aspx?id=1660

but unfortunately, i failed..nothing cames up and shoed up..i dont have any knowlegde with macro tough...

can someone help me doing the above tutorial step-by-step?

thanks and appreciate your inputs...


will pong December 31st 09 02:26 PM

insert formatted text using built-in outlook editor 2003?
 
Greetings Sue --

I'm running MS outlook 2003.

I am trying to annotate received emails and save them with my annotations. So my interest is to insert text
1) wherever I place my cursor (amidst existing text)
2) In a specified format (probably blue, arial)

I wrote a simple macro in MSWord 2003 that serves well -- it inserts a couple of blue parentheses wherever the cursor is, and I then simply click between the paren's, and type my annotations. I'd like to replicate this ability in Outlook.

Problem is (i'm learning) that MSWord is *not* consistently invoked when editing received messages (Edit EditMessage). So, can you help me with a similar macro for the built-in outlook-editor?.

Again, I'm running Office 2003. I'm on Windows XP Pro.

Thanks in advance.
--Will



Sue Mosher [MVP-Outlook] wrote:

Create macro to insert signature into email...
31-Mar-08

The sample at http://www.outlookcode.com/codedetail.aspx?id=3D615 should =
work fine with the built-in editor to insert a previously stored =
signature.=20

Note that using Ctrl+ key shortcuts isn't an option in Outlook. The =
closest solution is putting a command on the toolbar to run a macro and =
assign an Alt+ accelerator by putting a & in the command's caption.=20

--=20
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=3D54=20


"Fuel451" wrote in message =
...
particular=20
also=20
when I=20
built-in Outlook editor?=20
...
key to=20
some of=20
that might=20

Previous Posts In This Thread:

On Monday, March 31, 2008 8:35 PM
Fuel45 wrote:

Create macro to insert signature into email...
I need to create a macro that will allow a user to use CTRL + a key to
insert their signature into their new email. I've viewed and tried some of
the sample codes and links, but I'm not able get anything to work.

Could someone provide a working solition or a link to information that might
resolve the issue?

Thank you

On Monday, March 31, 2008 9:46 PM
Sue Mosher [MVP-Outlook] wrote:

In what version of Outlook?
In what version of Outlook? If pre-Outlook 2007, with Word or the =
built-in Outlook editor?=20

What have you tried and what specifically didn't work?=20

--=20
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=3D54=20


"Fuel451" wrote in message =
...
to=20
some of=20
might=20

On Monday, March 31, 2008 10:39 PM
Fuel45 wrote:

Currently running Outlook 2003 on most workstations.
Currently running Outlook 2003 on most workstations. This one in particular
is running version 2003 and I'm trying to use Outlook Editor. I've also
tried recording a macro with Word, but it doesn't seem to do anything when I
run the macro.


"Sue Mosher [MVP-Outlook]" wrote:

On Monday, March 31, 2008 11:55 PM
Sue Mosher [MVP-Outlook] wrote:

Create macro to insert signature into email...
The sample at http://www.outlookcode.com/codedetail.aspx?id=3D615 should =
work fine with the built-in editor to insert a previously stored =
signature.=20

Note that using Ctrl+ key shortcuts isn't an option in Outlook. The =
closest solution is putting a command on the toolbar to run a macro and =
assign an Alt+ accelerator by putting a & in the command's caption.=20

--=20
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=3D54=20


"Fuel451" wrote in message =
...
particular=20
also=20
when I=20
built-in Outlook editor?=20
...
key to=20
some of=20
that might=20

On Tuesday, April 01, 2008 9:21 AM
Fuel45 wrote:

I must have the process wrong, because the macro does not show up after I save
I must have the process wrong, because the macro does not show up after I
save it. Here's the process...

- tools, macro, macros
- insert macro name, click create
- paste the code in and save it
- when I go to tools customize, macros there's no macro listed
- when I go to the macros window, there's no macro listed

If I try to create a new macro, it brings up the editor and the code from
the previous macro and starts a new page.

"Sue Mosher [MVP-Outlook]" wrote:

On Tuesday, April 01, 2008 11:49 AM
Sue Mosher [MVP-Outlook] wrote:

What does your macro look like?
What does your macro look like? The sample is not a macro, but a =
subroutine that can be called by a macro, which would need to pass the =
name of the signature to the InsertSig procedure.

What code module did you create it in? (HINT: Use Alt+F11 to open the =
Outlook VBA directly.)=20
--=20
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=3D54=20


"Fuel451" wrote in message =
...
I=20
from=20
should work fine with the built-in editor to insert a previously stored =
signature.=20
closest solution is putting a command on the toolbar to run a macro and =
assign an Alt+ accelerator by putting a & in the command's caption.=20

...
particular=20
also=20
anything when I=20
built-in Outlook editor?=20
...
key to=20
tried some of=20
work.
information that might=20

On Thursday, June 12, 2008 12:32 PM
driko lane wrote:

Create Auto Refrence Number for outgoing message in outlook 2007
Hello all

I am trying to create a Auto reffrence number for each outgoing message i send from my outllok 2007. like so

Msg.No: 2333 Date: 2-12-1990 Time: 12:23 pm Jake

explanation
msg no -- is the message number itself
date -- is the date when themessage created
time --- is the time when themessage created
jake -- is the person who created / compose the message


i tried this tutorial http://www.outlookcode.com/codedetail.aspx?id=1660

but unfortunately, i failed..nothing cames up and shoed up..i dont have any knowlegde with macro tough...

can someone help me doing the above tutorial step-by-step?

thanks and appreciate your inputs...

On Thursday, June 12, 2008 1:00 PM
Sue Mosher [MVP-Outlook] wrote:

That's not a tutorial; it's a code sample.
That's not a tutorial; it's a code sample. It assumes that you know the =
basics of adding code to the Outlook VBA environment, as described at =
http://outlookcode.com/article.aspx?id=3D49

If you didn't understand part of the code sample or if part of the code =
did not run as expected, post a comment directly on that sample with =
details of the problem(s) you've encountered. The author also posted =
his blog address as a way of inviting comments and questions.=20

Other methods you can use:=20

1) Get the last number used in a folder. Listing 15.8 in my latest book, =
Microsoft Outlook 2007 Programming, demonstrates this. The code is =
usable in earlier versions and is available at =
http://outlookcode.com/member/book.aspx.=20

2) Use an Excel worksheet that contains VBA code to increment the =
number. See =
http://www.microsoft.com/office/comm...?dg=3Dmicroso=
ft.public.excel.newusers&mid=3D5489e140-9794-41b7-a9ba-1324e136ff3a

You could also use a text file to hold the number or, if this is for =
your personal use, an Outlook item.=20

--=20
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=3D54=20


driko lane wrote in message ...
message i send from my outllok 2007. like so
http://www.outlookcode.com/codedetail.aspx?id=3D1660
have any knowlegde with macro tough...


Submitted via EggHeadCafe - Software Developer Portal of Choice
C# Stock Quote Webservice with WebService Behavior
http://www.eggheadcafe.com/tutorials...ebservice.aspx


All times are GMT +1. The time now is 05:03 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com