Subject in Dlookup not pulling two values, need alternative

I tried adding two values for the Dlookup but was told it is not possible.   In my database I need to pull the body text and a subject and put it into a default email.  See the sample.
Who is Participating?
GozrehConnect With a Mentor Commented:
You should dim a separate verbal for each dlookup.
i showed you this in your previous question.

From all you questions it seems that you should go learn the basic of how to write and use VBA coding.
Rey Obrero (Capricorn1)Commented:
< In my database I need to pull the body text and a subject and put it into a default email>

you need two dlookup() , one for Subject and one for Body Text

where in your db are you doing this?
lehi52Author Commented:
You are correct.  I need to learn VBA.  But I really appreciate your help though.  Its really helped me get this up and running.  If I can get this email thing that you've been helping me with working it will be a huge help.  I tried the subject line code and it did not work.   Maybe I am doing something wrong.
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
and BTW it's not impossible to get Dlookup to return more then one value.


= Dlookup("[Address] & ';' & [City]","tblCustomers","[CustomerID] = 1")
Then do a split on the semi-colon.

Rey Obrero (Capricorn1)Commented:
yes, if the values you are looking for comes from the same record
lehi52Author Commented:
He was right it was answered in my previous post.
he needs one dlookup for subject and one for the body to be entered the the email, so he will need 2 separate dlookup's.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.