This will create the e-mail I want if I do a copy/paste value and
double click the cell where I pasted/value.

While I can do the 2 step tango, I want to automate the hyperlink for
the rest of my users. I can't seem to get a macro which can edit the
content, then exit out so that it is a hyperlink. Thoughts?


Sub mailto()
Application.Dialogs(xlDialogSendMail).Show
End Sub

="mailto:?bcc="&$F$33&"&subject="&$F$34&"&body="&$ F$35&"%0a"&$F$36&"%0a"&$F$37&"%0a"&$F$38&"%0a"&$F$ 39&"%0a$"&$F$40&"%0a"&$F$41

Live example: add the Mailto sub to your spreadsheet, then copy below
and paste into a cell, double click on it then hit enter. It should
appear as a hyper link, click the hyperlink and it creates an e-mail
and fills in the bcc, subject and body
---
&subject=test-test&body=Contact
namer%0aphone number%0acompany%0astreetaddress%0acity state,
zip%0a$quote%0aproduct
--