strMail Query!

[Bob Vance]

I am wanting to enter tblOwnerInfo.LastName,"," TblOwnerInfo.FirstName with
the tblOwnerInfo.Email (Address) to Sent Items to box?
Is this Possible

strMail = Nz(DLookup("Email", "tblOwnerInfo", "OwnerID = " & lngID), "")


Public Function OwnerEmailAddress(idOwner As Long) As Variant

If IsOwnerWithEmail(idOwner) Then
OwnerEmailAddress = DLookup("", "tblOwnerInfo", "[OwnerID]="
& idOwner)
Else
OwnerEmailAddress = Null
End If

End Function

 

[a a r o n _ k e m p f]

you've gotta tell us more about what you're trying to do dude

if you want to import from the sent items folder, then just right-
click import, files of type = 'outlook' and then browse for the sent
items folder