How to assign the value returned by the regex execute function to a variable?

Status
Not open for further replies.

AJBoy

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server 2013
I have a regex for pattern matching and once the match has been found the matched value has to be assigned to a variable

I used this snippet and it has been returning an error stating invalid procedure call or argument

Set M = regexpLocation.Execute(subjct)
Location = M(0).Value

How can i assign the matched value to Location, so that i can move the Location value to an excel cell?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
Z Outlook 365 Automatically assign categories to incoming mail in a shared folder Round Robin Outlook VBA and Custom Forms 1
R Auto Assign Category colours to Incoming Emails based on whom the email is addressed Outlook VBA and Custom Forms 3
R Assign Categories "Round Robin" style but in a shared mailbox but on specific emails only Outlook VBA and Custom Forms 8
P Auto assign shared mailbox Outlook VBA and Custom Forms 1
D Assign categories to outgoing emails Outlook VBA and Custom Forms 0
F How to assign a task to a public task folder? Using Outlook 1
soadfan assign category (VBA) Using Outlook 7
Diane Poremsky Assign one task to several people Using Outlook 0
Diane Poremsky Assign an Email Account to an Outlook Contact Using Outlook 0
E for Mac: Assign Task not available!? Using Outlook 1
E Outlook VBA to print attached Pdf to a fax printer and assign fax number Using Outlook 0
A Assign a unique number to every message I send Using Outlook 0
Z assign unique number email Using Outlook 8
J Assign a signature by external or internal reciepents. Outlook VBA and Custom Forms 1
P VBA to assign category on calendar item does not work ?? why ?? Outlook VBA and Custom Forms 5
S assign task programmatically Outlook VBA and Custom Forms 2
C Cannot assign a task from a public folder? Outlook VBA and Custom Forms 4
C Assign To and CC list while using Redemption.dll library Outlook VBA and Custom Forms 10
C How to assign icon to a button in Outlook Add-in Outlook VBA and Custom Forms 1
S Displaying Date Value In Formula Outlook VBA and Custom Forms 6
M copy field value to custom field Outlook VBA and Custom Forms 0
J VBA Cannot programmatically input or change Value for User Defined field Using Outlook 1
HappyDaddy007 "Size" on field chooser/column displaying incorrect value Using Outlook 3
V Why is "Value Required" checkbox greyed out for Dates? Outlook VBA and Custom Forms 2
Z Add ComboBox Value to Body of Email Outlook VBA and Custom Forms 1
S User Defined Fields adding new value (2) Using Outlook 0
C Copy Outlook contact field value to another field Outlook VBA and Custom Forms 1
M Outlook 2013 Replace Subject with Conversation (a "hidden" value). Outlook VBA and Custom Forms 0
S Find a cell value in excel using outlook vba Using Outlook 1
S SendFromAccount - Problem trying to test existing value in open email Outlook VBA and Custom Forms 2
N Lookup Value From Excel and Reply With Matching Value Using Outlook 0
R User Defined Fields adding new value Using Outlook 3
C Copy Cell value from Excel and paste into current email Outlook VBA and Custom Forms 10
B Conditional Formatting:How to use >1 value in a filter Using Outlook 7
M Copy "To" Address Value from a Newly Created Email to the "To" Address Field of Custom Form Using Outlook 4
J How to show the "value" of a user-defined Account field in a Contact Record BCM (Business Contact Manager) 2
D Custom Form - Show field-filled doc a or b based on value of field x Outlook VBA and Custom Forms 4
S Outlook code to validate textbox value Using Outlook 1
J How to create fields that will use the same value on different record types BCM (Business Contact Manager) 2
S Outlook custom checkbox not changing value Using Outlook 0
S Displaying the Remind Beforehand Value in Calendar List View Using Outlook 2
K TextBox on Custom Form Page :: Passing value from sender to the recipient Outlook VBA and Custom Forms 1
O Meeting Item SentOn Value Using Outlook 3
J Outlook 2010 Forms Help Needed "A field in this form requires a value." Using Outlook 6
C Custom Contact form - erase default value Using Outlook 0
F Change default value of date/time type from "None" to Blank Using Outlook 1
R Need code to gather value of custom field on addressentry.details dialog box Using Outlook 3
G Displaying value of task subject field as values from two custom fields Using Outlook 4
T You must Provide a value for this property on powershell cmdlet Exchange Server Administration 3
T To value Outlook VBA and Custom Forms 1

Similar threads

Back
Top