E
excel programming
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
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