passing strings into the email subject

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

Guest

I have a module that contains a function that asks for the user to enter a
text string. This string is then assigned to a variable called 'block'.
What I am trying to do is get this string to appear in the subject line of
the email message but don't seem to have any luck with the syntax.

Currently I've tried the following in the subject line of the sendobject
event in the macro:

=block()
=[block]
=block
=&"block name is "&block

but none work. Could someone please point me in the right direction ?

thanks for reading !
 
In the to: section of the SendObject macro put
=InputBox("Enter the subject of this email")

Chris
 
Back
Top