+ Reply to Thread
Results 1 to 6 of 6

Standard Email Macro connecting Body to Subject

  1. #1
    Registered User
    Join Date
    01-28-2010
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    20

    Smile Standard Email Macro connecting Body to Subject

    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

  2. #2
    Registered User
    Join Date
    11-09-2008
    Location
    germany
    Posts
    74

    Re: Standard Email Macro connecting Body to Subject

    I dont understand.

    Where does the body text come from? Does it come from a database or from a form or something?

  3. #3
    Registered User
    Join Date
    01-28-2010
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Standard Email Macro connecting Body to Subject

    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

  4. #4
    Registered User
    Join Date
    11-09-2008
    Location
    germany
    Posts
    74

    Re: Standard Email Macro connecting Body to Subject

    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?

  5. #5
    Registered User
    Join Date
    01-28-2010
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Standard Email Macro connecting Body to Subject

    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?

  6. #6
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Standard Email Macro connecting Body to Subject

    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...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1