Mailto hyperlink or VBA

[Redcurrant]

Hi all,

Ok, so I'm trying to send an email that extracts data from several cells (see image 1) so the email looks like image 2. However, I'm falling foul to the 255 character limit on the hyperlink, with the 'SEND' hyperlink changing to '#VALUE!'


How can I rectify this? (Preferably without VBA)

 

[Debaser]

Without VBA I don't think you can.

 

[Redcurrant]

I'll use VBA if a need to. I only prefer the hyperlink as it turns purple when sent, so you know it's been actioned. But if VBA is needed then so be it.

I did try a simple formula but all that did was populate the email with the cell numbers rather than the cell content.

 

[Debaser]

You could still use hyperlinks together with VBA. Have the hyperlink simply link to the cell it is in and then use the Worksheet_FollowHyperlink method to do the actual work.