Adding a field to a message body (1 Viewer)

[Dan Pope]

Hi

I'm trying to add a supplier name to the body of my email message.

so far I can get this return

Please find attachment for the discrepancy by 123

But I want 'Company' to display not 'ID'

to get the above, this is in the Expression Builder.

="Please find attachment for the discrepancy by " & Nz([Customer],"")

What am I doing wrong?
Please let me know if you need anymore info?

 

[theDBguy]

Hi. Are you, by any chance, maybe using a lookup field in your table?

 

[Dan Pope]

Yes. is this my problem? D-Lookup??

 

[theDBguy]

Yes. is this my problem? D-Lookup??

Hi. Yes, either that or JOIN the lookup table in your query to have the company name available to your form/code.

 

[Dan Pope]

thank DB fixed it
="Please see Attached Discrepancy for the latest " & DLookUp("[Company]","Customers","[ID]=" & Nz([Customer],0)) & " Shipment"

 

[theDBguy]

thank DB fixed it
="Please see Attached Discrepancy for the latest " & DLookUp("[Company]","Customers","[ID]=" & Nz([Customer],0)) & " Shipment"

Congratulations! Glad to hear you got it sorted out. Good luck with your project.