email help!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a macro to send an email. It pops up Outlook just fine,
however it is not grabbing all of the data in a field. It is limiting it.
Here is the macro code

To: =Nz(DLookUp("[E-Mail Address]","Contacts","ID=" & Nz([Assigned_To],0)))

Message Text: ="Issue ID: " & [IssueID] & Chr$(13) & "Narrative: " &
[Narrative] & Chr$(10) & "Update Narrative: " & [Update_Narrative]

The Narrative Field and Update Narrative field is a Memo field in the table.
Please help me as soon as possible.
 
Bronen,

I am not sure whether this will be the complete answer to your problem.
But you haven't got the CR and LF correct. Try changing it like this...

Message Text: ="Issue ID: " & [IssueID] & Chr(13) & Chr(10) &
"Narrative: " & [Narrative] & Chr(13) & Chr(10) & "Update Narrative: " &
[Update_Narrative]

If this still causes a problem, can you explain what you mean by "it is
limiting it". And also can you let us know the details of the query
that the form is based on. Thanks.
 
Ben,

I am sorry, I do not have any experience with this problem. But I would
try this next... Construct the concatenation in the query that the form
is based on, rather than in the macro argument. In other words, make a
claculated field in the query, by typing into the Field row of a blank
column in the query design grid:
Message: "Issue ID: " & [IssueID] & Chr(13) & Chr(10) & "Narrative: "
& [Narrative] & Chr(13) & Chr(10) & "Update Narrative: " &
[Update_Narrative]

You can run the query to see if all the data is returned in the query.

Then, in the macro Message Text argument, you just neet to refer to this
field directly...
=[Message]

Let us know how that goes.
 
Ben,

Was this your interpreatation of my previous suggestion? If so, that's
not what I meant. Can you post back with the SQL view of the query?
Does it contain a calculated field that returns the text you want for
the message? Is this the query that the form is based on (Record
Source)? If so, enter the name of the calculated field in the macro
argument, not the name of the query itself.
 
Back
Top