Selecting "Mileage" field on "Detail" page

Status
Not open for further replies.

Steve Miller

New Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
Hi
I'm looking to paste text from an Outlook task notes section into the Mileage field on the Details page. Or I could just update the contents of the Mileage field.

Having trouble finding the right objects. Seems like a simple sub. Anyone have a suggestion?

Thanks! Steve.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
F2 in the VBA editor will bring up the object model reference which can be helpful in finding field names.

Is the value you want from the body the only thing in the body field?

The macro here gives the basic format - Working with All Items in a Folder or Selected Items

You'd use the .mileage field name
With obj
.Mileage = "whatever"
.Save
End With

With obj
.Mileage = .body
.Save
End With
 

Steve Miller

New Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
Thanks Diane,
"Is it the only thing in the text field?"
Not sure of the Q, but do not want to transfer all text from the Task notes to the Mileage field

I want to transfer just the text on the same line as my curser in the task notes to the mileage field.
Eg.
__ Follow up with Dave on open issue
__ Call John and give summary from Dave

where the curser is at position 1 of the "Dave" line

I was hoping there may be a reference similar to the excel code below to move the curser to the Mileage field
sheets ("Sheet 2").select

Steve.

F2 in the VBA editor will bring up the object model reference which can be helpful in finding field names.

Is the value you want from the body the only thing in the body field?

The macro here gives the basic format - Working with All Items in a Folder or Selected Items

You'd use the .mileage field name
With obj
.Mileage = "whatever"
.Save
End With

With obj
.Mileage = .body
.Save
End With
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
K Selecting a folder from an entry in a Listbox Outlook VBA and Custom Forms 1
N Selecting multiple calendar items Using Outlook 4
I Selecting folder with msoFileDialogFolderPicker Outlook VBA and Custom Forms 0
S Automatically selecting folders and deleting messages in Outlook VBA Outlook VBA and Custom Forms 7
S Creating Email - Selecting Pre-Defined Text Using Outlook 2
P Selecting specific calendar from Excel Outlook VBA and Custom Forms 5
RalphG101 No indication of attachment, when selecting file, send to outlook. Using Outlook 0
A Auto Insert of filename when selecting 'Remove Attachment' Using Outlook 1
R VBScript Sendmail not selecting correct 'from' address Outlook VBA and Custom Forms 3
230Grains iCloud COM Module Keeps de-selecting in Outlook 2013 Using Outlook 1
F Automatically close email after selecting mark unread Using Outlook 1
S categories are being cut off after selecting from category pop up form Using Outlook 3
S Outlook Custom form - selecting text in read page Using Outlook 0
V Selecting multiple folders Using Outlook 2
D Selecting shared calendar for appointment/meeting templates Using Outlook 2
B MS Office 2010: Word email merge not selecting default Outlook account Using Outlook 1
M Outllook vba - selecting a folder Using Outlook 1
C Selecting days in business notes BCM (Business Contact Manager) 0
A Pull mail without marking and processing, only by selecting it Using Outlook 1
T Distribution Lists, Selecting members, filtering members out of the selection process (not one by one) Using Outlook 2
S E-mail contact Prompts when selecting TO: Using Outlook 2
T selecting and view multiple emails Using Outlook 2
G Selecting contacts from Groups within the Address Book Using Outlook 2
C Selecting calendar causes problems Using Outlook 2
J In Outlook 2010 selecting the Junk drop down for a message & then "Never block..." fails to add entr Using Outlook 7
S Unable to go to Inbox/Contacts Folder after selecting Public Folders. Using Outlook 1
C after selecting 'reply' font size is VERY small Using Outlook 2
A Selecting multiple folders within pst files? Using Outlook 2
S List Box - Selecting Multiple Items (Saving) Outlook VBA and Custom Forms 2
S Create a clickable custom column field Outlook VBA and Custom Forms 0
B User defined field for messages with 'me' in the [To], [Cc] line Using Outlook 0
V Limiting text length in free text field Outlook VBA and Custom Forms 2
C Outlook 2016 Conditional Format for User Defined Field Using Outlook 1
C Copy Outlook contact field value to another field Outlook VBA and Custom Forms 1
A new labeled phone field Using Outlook 4
V Making a Date field mandatory in outlook form Outlook VBA and Custom Forms 2
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
BretAB Is it possible to add a lookup field to a Message form? Outlook VBA and Custom Forms 4
N Exporting IM Address field Using Outlook 2
M Using field names to capture a data element Using Outlook 0
J How to restore field no longer visible in field chooser? Using Outlook 1
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
R What's supposed to appear when just clicking into the search field? Using Outlook 7
A Missing context menu on Location field Using Outlook 2
G Entered data in custom field goes in card and does not stay in list view Outlook VBA and Custom Forms 1
C Changed By field not displaying individual user's name in O365 Shared Mailbox Using Outlook 9
M Making Subject field writable (disable Read Only) Outlook VBA and Custom Forms 2
C Import Outlook 2016 contacts into to: field Using Outlook 1
T Source of Outlook 2016 Address field dropdown "Other Suggestions" Using Outlook 3
S BCM Compulsory field, New opportunity Outlook VBA and Custom Forms 0
Similar threads


















































Top