passing strings into the email subject

C

Chris

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 !
 
C

Chris Reveille

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

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top