ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Inserting Buttons as Hyperlinks (https://www.excelbanter.com/excel-worksheet-functions/149903-inserting-buttons-hyperlinks.html)

Melo

Inserting Buttons as Hyperlinks
 
I need to create buttons on a spreadsheet that will be hyperlinks to email.
But I need the spreadsheet to be sent as an attachment to the person from a
list. So in short I need a button that will look at the name of the person
and put in their email address and then email them with the spreadsheet as an
attachment.

Ron de Bruin

Inserting Buttons as Hyperlinks
 
Hi Melo

Start here
http://www.rondebruin.nl/sendmail.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Melo" wrote in message ...
I need to create buttons on a spreadsheet that will be hyperlinks to email.
But I need the spreadsheet to be sent as an attachment to the person from a
list. So in short I need a button that will look at the name of the person
and put in their email address and then email them with the spreadsheet as an
attachment.


Melo

Inserting Buttons as Hyperlinks
 
Thank you,

That is a tremedous help to me. Now 1 more question if I want excel to look
at a cell to get the email address- or even a list of address-- can I do it
with this template or do I need to do a Macro?

Thank You,

Melo


"Ron de Bruin" wrote:

Hi Melo

Start here
http://www.rondebruin.nl/sendmail.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Melo" wrote in message ...
I need to create buttons on a spreadsheet that will be hyperlinks to email.
But I need the spreadsheet to be sent as an attachment to the person from a
list. So in short I need a button that will look at the name of the person
and put in their email address and then email them with the spreadsheet as an
attachment.



Ron de Bruin

Inserting Buttons as Hyperlinks
 
Hi Melo

On every code example page there is a Tip link
You can find the information there

This is not possible with the add-in or the templates



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Melo" wrote in message ...
Thank you,

That is a tremedous help to me. Now 1 more question if I want excel to look
at a cell to get the email address- or even a list of address-- can I do it
with this template or do I need to do a Macro?

Thank You,

Melo


"Ron de Bruin" wrote:

Hi Melo

Start here
http://www.rondebruin.nl/sendmail.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Melo" wrote in message ...
I need to create buttons on a spreadsheet that will be hyperlinks to email.
But I need the spreadsheet to be sent as an attachment to the person from a
list. So in short I need a button that will look at the name of the person
and put in their email address and then email them with the spreadsheet as an
attachment.




All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com