Hi, I coded the following statement in my report.

URL=mailto:(Email ?Subject=Subject),TARGET=BLANK,$

where Email is the actual email address and Subject is the purchase order number i.e PO # 12345678.

But when I clicked on the column to send email, WF generated the '&' at the end of the email address i.e joedoe@dotcom.com&.

Is anyway the & remove from the email address?

Please help. Thanks.

This message has been edited. Last edited by: Kerry,

I think you will have to do it with a JavaScript function. Take a look at this example:

SET BYDISPLAY = ON
-RUN

TABLE FILE CAR
PRINT
MODEL
BY COUNTRY
BY CAR
ON TABLE HOLD FORMAT HTMTABLE
ON TABLE SET STYLESHEET *
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=8, $
TYPE=DATA, COLUMN=COUNTRY, JavaScript='fnMail(COUNTRY CAR)', $
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<SCRIPT LANGUAGE=JAVASCRIPT>
function fnMail(Email,Subject)
{
window.location = 'mailto:' + Email + '?Subject=' + Subject;
}
</SCRIPT>
!IBI.FIL.HOLD;
-HTMLFORM END

Francis, you totally rock, you know that!
thank you!

Susannah,

I never congratulated you on achieving Master status, so, congrats!

ROFL

FYI,

The user managed to resolve the issue using the following:

DEFINE FILE VPAY
SUBJECT/A50 = 'PO # ' || po_nbr;
NEW_EMAIL/A200 = 
'<a href="mailto:' || Email || '?subject=' || SUBJECT || '">' || Entered_By || '</a>';
END
TABLE FILE VPAY
PRINT
NEW_EMAIL

Congradulations and thanks for sharing.

Cheers,

Kerry

This message has been edited. Last edited by: Kerry,

Kerry,

Would you mind reposting your message with the option "Disable HTML" selected?

Thanks,

Francis.

How do you add the BODY to he NEW_EMAIL field?
thanks

quote:

Originally posted by MMcDonald:
How do you add the BODY to he NEW_EMAIL field?
thanks

Shooting from the hip, would it be:

DEFINE FILE VPAY
SUBJECT/A50 = 'PO # ' || po_nbr;
BODY/A100    = 'I have an amazing business proposition for you. The leader of my country is in exile and all I need is your bank account number to retrieve untold millions in wealth...';
NEW_EMAIL/A200 = 
'<a href="mailto:' || Email || '?subject=' || SUBJECT || '&|body=' || BODY ||'>' || Entered_By || '</a>';
END

TABLE FILE VPAY
PRINT
NEW_EMAIL

See: http://email.about.com/od/mail.../mailto_elements.htm

-ABT