Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^3: Sending email from excel by one click

by martell (Hermit)
on May 25, 2011 at 20:45 UTC ( [id://906705]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Sending email from excel by one click
in thread Sending email from excel by one click

Normally you can. Simply use the concatenation function '&' in excel. For example:

=(Hyperlink("Mailto:me@home.com?Subject=" & A3 & "&Body=" & A2 & "Kind + regards"))

This will put the content of cell A3 in the subject and A2 into the body.

Search in google on: 'excel mailto body' for other examples.

Kind Regards

Martell

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://906705]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (4)
As of 2024-03-28 08:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found