Mailto function with email signature?

[sarav99]

I have an excel sheet I use as an address book to send out a set email. I use this formula on each line. However, the generated email does not display my signature automatically. Can anyone advise if this is possible?

=HYPERLINK(CONCATENATE("mailto:",E21&";"&F21,"?subject=",C21&$V$1, "&body=",C21, $W$1),"E-mail")

[dominicb]

Good morning sarav99

I'm not certain that you can incorporate the signature by hyperlinking to "mailto:" in this fashion.

If you are up to stepping things up a gear, then you could use a macro to send your e-mail, whereby you would be able to incorporate a signature.

Ron de Bruin has an article here that talks you through several ways of accomplishing this.

HTH

DominicB

[sarav99]

Thank you. I'll go try that.

[sarav99]

Thank you.

I now have the code below which works well.
But is there any way to make the cell references relative so I can repeat for a list?
ie .To = column to the left of macro button

Please Login or Register  to view this content.

[dominicb]

Hi sarav99

Administrative Note:

Welcome to the forum.

Please remember in future you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(I have added them for you on this occasion)



Try using this code instead :

Please Login or Register  to view this content.

HTH

DominicB

[sarav99]

Thank you for your help. Although it seems I have explained myself badly.

I have an address book in the form of an excel spreadsheet. I wish to add a button to each row which sends the generated email to the email address on that row not to all email addresses.

[dominicb]

Hi sarav99

OK, you've lost me completely now. Perhaps it's time to upload a sample file so that I can see what you mean.



Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitise the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[sarav99]

Please see attached spreadsheet.
I have quite a few suppliers so I don't wish to write a new macro for each line.

Please Login or Register  to view this content.

[dominicb]

Hi sarav99

How about a slight change? You have one button linked to this macro, and that is your generate e-mail button. The addressee of the e-mail is dependant upon which is the active cell on your selection page. So, any cell selected on row 4 will go to john, any cell on row 2 will go to Sara etc … ? It's easier to do it that way, than the current way, which involves detecting that location of each button, so we take the path of least resistance?

Please Login or Register  to view this content.

HTH

DominicB

[sarav99]

You are a superstar.
I can not thank you enough.

Sara