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.
1.accdb
lehi52Asked:
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.
0
 
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?
0
 
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.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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

ie.

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

Jim.
0
 
Rey Obrero (Capricorn1)Commented:
yes, if the values you are looking for comes from the same record
0
 
lehi52Author Commented:
He was right it was answered in my previous post.
0
 
GozrehCommented:
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.
0
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.