![]() ![]() Found = True Then = RGB(0, 102, 204)įirst: You will need macro security set to low during testing. objSel.Range, strLink, "", "", strLinkText, "" StrDeletePhone = "+1 2 Canada (Toronto ON)" ObjItem.HTMLBody = Replace(objItem.HTMLBody, "English (United States)", "") ' user wanted to clean up phone # left in If objInsp.EditorType = olEditorWord Then You'll also need to change the phone number strings to the correct values.Īfter creating the Skype meeting, run the macro to update the numbers.ĭim strLink As String, strLinkText As Stringĭim strDeletePhone As String, strAddPhone As String To use this macro you need to set a reference to the Word Object Model in the VBA editor's Tools, References dialog. It then finds the remaining numbers and deletes the entire row. This code sample uses the Word object model to select the numbers you are replacing and replaces then with the new number and new hyperlink. There are two ways you can do this: create HTML stationery to replace the template and use Regex to get the meeting code so you can recreate the link to the meeting or use a macro to delete or replace the numbers in the meeting invitation, using the method in " Use Word Macro to Apply Formatting to Email". ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |