Open URL email help

[CWH]

Can anyone tell me why the first calc below works but the 2nd fails to put the e-mail address into outlook? They're from diff dbs so field names are diff, but the scripts to call them are same (Open URL, No dialog, name of calc field)?

"mailto:" & PI_Email & "?subject=" & "Cycle#" & CYCLE# & "-" &Type_of_Grant & "-" & ID#

"mailto:" & E_mail & "?subject=" & "Global Strategies Invitation"& "?body=" &"Dear " &First Name & Last Name

thanks for any suggestions

[Chuck]

If the email address isn't getting to the email program, first check to make sure that the calculation is correct. Place the calc field on a layout so that you can take a look at what it actually has. If there is not an email address in the correct place, put the email address field on the layout too. It's probably a problem with the contents of the field and not the Open URL step.

Chuck

[CWH]

Thanks for that advice. It helped me figure out what an IDIOT I am. I put the calc and e-mail field in a layout and it still wasn't showing up, allowing me to brilliantly deduce that there is no e-mail address in the random record I was testing the script on.

Thanks again.