Finding email addresses using VBA

[P.Malius]

Hello,



I have a simple database that is used to track documents, when a new document is entered I have a bit of code that I use to send an email out to specific recipicants (depending on the document). As it stands I have a fake email in the address section, I would like to have the code pick up the emails that i have entered into the form to save me re-typing all the time. Is this possible?

Below is my code:

Private Sub Command48_Click()
DoCmd.SendObject _
    , _
    , _
    , _
    "John.smith@no-where.com" _
    , _
    , _
    , _
    "Specification has been issued for review", _
    "A Specification has been issued and is awaiting your review. Please complete this reviw with 14 DAYS. Record number: " & Forms!frmSpecification.ID & ".", , _
    True
    
    

End Sub

Any help would be greatfully appreciated.

[P.Malius]

It appears I have solved my own problem. The 'Forms!frmSpecification.**' bit of code will work in the address section however I have a dash in my fields name containing the addresses which was causing it not to work.