Live Meeting Location populate from body

Status
Not open for further replies.

Josh

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
I am trying to write a script to auto populate the location when creating a live meeting request with the Conference ID and Passcode from the auto generated body. I have only found code to take an incoming message and find the data using ".pattern" but I can't figure out how to get this to the location. This is so when making a live meeting request the attendees can just click the number link on their phone while traveling to get through the call. The Conference ID and Passcode are auto generated for each meeting. Oh, and I am very new to writing VB code... Here is an example:

Body:
Phone number 1-800-123-4567
Conference ID: 123456
Passcode: 1234

into Location field - 18001234567,,123456#,,1234#

Thank you!
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
you'll use regex .pattern to grab the numbers and code and put it into the .location field.

Something like oAppt.location = strPhone &",," & strID & "#,," & strPass

Are you creating a new appointment/meeting request or updating the current request?

The second macro example shows how to get multiple values using regex. It's puitting everything together into 1 string too - although it might not work since you need to add the #.
strSubject = Replace(strSubject, "-", "") <== removes the dash

testSubject = testSubject & ",," & Trim(strSubject) <== gotta figure out how to add the # to this, otherwise you'll need to use separate str variables.
 

Josh

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
you'll use regex .pattern to grab the numbers and code and put it into the .location field.

Something like oAppt.location = strPhone &",," & strID & "#,," & strPass

Are you creating a new appointment/meeting request or updating the current request?

The second macro example shows how to get multiple values using regex. It's puitting everything together into 1 string too - although it might not work since you need to add the #.
strSubject = Replace(strSubject, "-", "") <== removes the dash

testSubject = testSubject & ",," & Trim(strSubject) <== gotta figure out how to add the # to this, otherwise you'll need to use separate str variables.

Awesome, thank you. This is indeed when I am creating a new meeting request which is why I am stuck with your example to take an incoming email and put the info in the subject, then forward. I will mess with this a bit more but I am almost positive I will have questions since I am feeling a little clueless.
 

Josh

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Here is an exact example of what is in the auto generated body when making a live meeting, since I just looked and there are no "-" in the number:

AUDIO INFORMATION
To join a meeting from your phone, dial in using the following information:
Phone: +1 (847) 719 8600 [English, French]
Find a local phone number for your region

Conference ID: 10652494
Passcode: 6731
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Not ignoring you, but I'm out of town for the holiday weekend + a few extra days.

Will you need to remove the space and () from the number? Grabbing the id and passcode is a piece of cake.


Sent from my iPad using Tapatalk
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
B Live meeting templates Using Outlook 1
E Work uses live accounts for emails for all employees. Can we use the outlook calendar to give the employees an universal work schedule calendar? Using Outlook 1
T Can't send email through connected account (outlook.live.com) - goes to Drafts folder Using Outlook.com accounts in Outlook 3
Diane Poremsky "Live" Group Calendar Tools Using Outlook 0
Diane Poremsky Disable Live Preview in Outlook and Word Using Outlook 0
L Showing @live account in outlook 2013 calendar as private appointment Using Outlook 1
R Cannot Synchronize Outlook To Windows Live Hotmail Account Using Outlook.com accounts in Outlook 2
L Cannot send emails through @live.co.uk account in outlook 2013 Using Outlook 0
L Cannot send emails through @live.co.uk account in outlook 2013 Using Outlook 2
I syncing outlook 2007 with live. com Using Outlook 4
V iCloud and Outlook 2007 iCloud - Initial setup with live data on all machines Using Outlook 2
P How to fetch ALL (not only Inbox) emails from Hotmail/live server (by POP3)? Using Outlook 1
B Outlook 2007 and Live Calendar Stopped Synching Using Outlook.com accounts in Outlook 4
J Outlook Calendar will not sync with Windows Live.com account Using Outlook 9
H Importing Windows Live Mail Contact into Outlook 2010 Using Outlook 0
C migrating from Windows Live Mail over to Outlook 2010 Problems ... Using Outlook 2
B Sharing Contacts via Live Using Outlook 2
D How to correct Outlook Connector Live ID Using Outlook.com accounts in Outlook 1
D Please help. My live.edu mail will not sync. Using Outlook.com accounts in Outlook 1
N [SOLVED] Live Contacts Not Syncing with Outlook Using Outlook.com accounts in Outlook 8
S Trouble setting up Outlook Connector to sync with windows live Using Outlook.com accounts in Outlook 3
Diane Poremsky Facebook and Live Providers for Social Connector Using Outlook 2
P Windows Live Calendar sync Outlook Using Outlook.com accounts in Outlook 4
B how do i sync windows live calendar with my Blackberry Using Outlook.com accounts in Outlook 2
U how to export my calendar to windows live calendar Using Outlook.com accounts in Outlook 1
A RE: outlook 2003 and live.com Using Outlook.com accounts in Outlook 1
diver864 vba for a rule to automatically accept meeting requests with 'vacation' in subject, change to all-day event, change to free, don't send reply Outlook VBA and Custom Forms 1
P Scheduling a meeting in Outlook Outlook Wishlist 3
S Skype for business meeting vba code Outlook VBA and Custom Forms 1
A Unable to save recurring Meeting to Documents folder due to error Using Outlook 2
S Meeting with Time Slots Using Outlook 2
egarneau Meeting updates with external contacts (GMail) Using Outlook 1
L automaticaly create a teams meeting with a sync Using Outlook 0
R auto send email when meeting closes from a shared calendar only Outlook VBA and Custom Forms 2
S Meeting Invite arrives from Wrong ("send-as") Sender Using Outlook 1
Daniel Schunk Meeting responses are not shown in the status area Using Outlook 2
A End-time meeting reminder (or "negative" time relative to the meeting start time) Using Outlook 1
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
T Pick-a-Meeting in Outlook 365 Using Outlook 2
J No response required when delegate arranging meeting Using Outlook 0
S Accepting meeting request from calendar keeps the meeting request in the inbox Using Outlook 2
D Add all meeting rooms to the meeting request by default Outlook VBA and Custom Forms 0
Rick Rickert Would like bigger meeting notifications. Using Outlook 3
G Auto accept meeting request for non primary account Outlook VBA and Custom Forms 1
D Next Available Meeting with Userform Variables Outlook VBA and Custom Forms 1
J Outlook 2016 shows Meeting Organizer in Calendar View Using Outlook 5
C Update Notes for Meeting Attendees Using Outlook 8
D Outlook macros to create meeting on shared calendar Outlook VBA and Custom Forms 10
P Skype contact icons have disappeared at the bottom of email and meeting objects Using Outlook 2
T Double clik behavior on agenda open a new meeting request Using Outlook 1

Similar threads

Top