I have created a form to send emails with attachments.
The attachment path is specified in an unbound field which I have called [ToAttach]
Rather than typing in the path, I want to use the browse function.
I have inserted a browse button and can browse for the required file using following, but can't figure out how to place the file name in the unbound field as a string.
The attachment path is specified in an unbound field which I have called [ToAttach]
Rather than typing in the path, I want to use the browse function.
I have inserted a browse button and can browse for the required file using following, but can't figure out how to place the file name in the unbound field as a string.
Code:
Dim f As Object
Set f = Application.FileDialog(3)
f.AllowMultiSelect = False
f.Show