in reply to Sending email from excel by one click

Are you creating the excel sheet via Perl some how? Sounds like you want to create a Mailto link. See the write_url method of Spreadsheet::WriteExcel.

Replies are listed 'Best First'.
Re^2: Sending email from excel by one click
by pavan6754 (Initiate) on May 24, 2011 at 18:09 UTC

    yes Marto i am creating excel sheet using Perl script

    but using write_url i can create Mailto Link but what about body(Body should contain filenames owned by owner..)

    So.. Question is i need to create email body which takes cell values as input.

Re^2: Sending email from excel by one click
by pavan6754 (Initiate) on May 24, 2011 at 18:00 UTC

    sorry for the confusion..

    excel sheet is generated through perl script....

    So.. User used to type mail for each owner manually..

    i want to automate this wrk also..can you please help me ...