add varible name to macro

[rainbows]

i would like to be able to put the suppliers contact name in this macro but i dont know where to locate ir

i would to be able to say for example "paul" please find attached NCR


thanks
steve

 

[jdraw]

I don't use macros. But do you have the 'Supplier Contact's first name" somewhere in your table?
You might be able to concatenate the First name and your "subject".
Definitely untested --just a thought regarding possible approach.

 

[Gasman]

i would like to be able to put the suppliers contact name in this macro but i dont know where to locate ir


View attachment 104651



View attachment 104652
i would to be able to say for example "paul" please find attached NCR


thanks
steve

So that would be Message Text then?

 

[GPGeorge]

So that would be Message Text then?

Yup.

But you could confirm that by using the "try it and see what happens" method.

 

[rainbows]

this shows the firstname in the suppliers table and the NCR detailsi would send

 

[theDBguy]

Using macros, I would recommend using the Set LocalVar action to store the value in a local variable first, so you can then concatenate it into the email message.

 

[ebs17]

I don't use macros either. But I think TempVars were introduced especially for them.

 

[rainbows]

i managed to get snippest from posts on here and managed to do it like this

thanks for your help

steve

Private Sub cmdEmailCustomer_Click()
 Dim strTo As String
    Dim strSubject As String
    Dim strMessageText As String
    
    Me.Dirty = False
    strTo = Me.[E-Mail address1]
    
    strSubject = " NCR Number " & Me.[loss order number]
    strMessageText = Me.Firstname & "," & _
        vbNewLine & vbNewLine & _
        "Please See Attached NCR." & _
        vbNewLine & vbNewLine & _
        ""


    DoCmd.SendObject ObjectType:=acSendReport, _
        ObjectName:="SEND NCR", _
        OutputFormat:=acFormatPDF, _
        TO:=strTo, _
        Subject:=strSubject, _
        messageText:=strMessageText, _
        EditMessage:=True
End Sub