shockey8oz
New Member
- Joined
- Sep 17, 2012
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Good morning everyone-
I am trying to automate a task at work.I have create a "form" email for my employees to use in Outlook. They open the "form" email and change two items, a ticket number and a location. They type this information manually. It has been requested that we add a hyperlink to our database that takes someone directly to the ticket. The ticket is unique for every email.
example: www.aol.com/ticketID=12345
My thoughts were to create a macro to attach the hyperlink as the send button is clicked (similar to how you can run a macro in excel upon opening or closing a spreadsheet).
1. Is this even possible?
2. Any ideas on how to create this?
Thanks Aaron
I am trying to automate a task at work.I have create a "form" email for my employees to use in Outlook. They open the "form" email and change two items, a ticket number and a location. They type this information manually. It has been requested that we add a hyperlink to our database that takes someone directly to the ticket. The ticket is unique for every email.
example: www.aol.com/ticketID=12345
My thoughts were to create a macro to attach the hyperlink as the send button is clicked (similar to how you can run a macro in excel upon opening or closing a spreadsheet).
1. Is this even possible?
2. Any ideas on how to create this?
Thanks Aaron
