Pick Combobox Column To Display (ID Vs Name) Via VBA

I have some vba code that opens up notepad and populates it with data from Access 2010. Everything works great including the notepad function, the database, and how the data is stored and displayed in the table/form.

The problem: I want to display the service name not the ID in notepad

I passed the field that I want to include in notepad as a string. However, it returns the ID and not the name of the person.

I don't want to change anything in the form or field property because it works perfect as is.

Is there a way to pick which column to display in the Email by vba code?

Column 0 = the ID and Column 1 = the name

Code:
Me.fieldName.Column(1)
^^That doesn't work for me

Here's my code (it works)

Code:
Private Sub cmdNoteAccept_Click()
Dim strCode As String

strCode = strCode & Me.Servicer & ": "
strCode = strCode & Format(Me.DateCreated, "MM/DD/YYYY")

strCode = strCode & "Insert message here"

Shell "Notepad.exe", vbNormalFocus
SendKeys strCode, True
End Sub