DLookup Function

[Novice1]

I know how to use the DLookUp function in a report ...

=DLookUp("HeaderLine1","tblLetterHead","LetterheadID = 1")

Can I use with SendObject? I add the code (without = ) without success.

Any suggestions?

 

[Novice1]

Assign a variant

Dim varX As Variant
varX = DLookup("ReturnEmail", "tblCritiques", "CritiqueID = 1")

 

[pbaldy]

Looks like you got it? You'd use that variable in SendObject.