Hi,
I would like to write a standard email macro.
Starting value should be:
“
Subject: - Should be Bland
Body:
Some initial text ("I would like to book the following conf room")
Building:[xx]
Date: [xx]
Time: [xx]
Number of people: [xx]
Br Jesper
“
Starting macro:
Text in between the [] in the Body should automatically be written in the Subject.
“
Subject: Flatiron building, 2010-09-10, 09:00, 6 people
Body
Building:[Flatiron building]
Date: [2010-09-10]
Time: [09:00]
Number of people: [6]
Br Jesper
“
Appreciate the help.
Br Jesper
I dont understand.
Where does the body text come from? Does it come from a database or from a form or something?
The text comes from a email signature.
Then I enter the text manually between the [] in the body:
Building:[Flatiron building]
Date: [2010-09-10]
Time: [09:00]
Number of people: [6]
Once i have done that, the text between the [] should "magically" pop up in the subject field.
//Jesper
Have you started to code this?
Do you use Outlook?
How does the text in this signature look? How do you get it? Is it in the normal Outlook signatures file?
I have not started to code it. Yes, I use Office 2007.
Text in signture:
Hi
Please book a meeting room in
Date:
Time:
Number of people:
Br Jesper
I am not sure how to do but it might be possible to write a macro that recognize some character, like []. The macro should address, “put whatever that is between [] and put in the Subject field”…
Do You have any suggestion?
Hi,
Have you considered using the built-in functionality of Outlook's calendar?
The date & time are an intimate part of booking an appointment/meeting, buildings or meeting rooms can be added as a list of Locations/Resources (I think?) and the number of people could potentially be inferred from the list of Invitees.
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks