Send Email With Cell Conent as Part of the Subject

I

igbert

Hyperlink is able to send email with cell content in the Subject line.

My Case

=HYPERLINK("mailto:Collections_Admin?subject=Overdue Balance " & "_"&
'Sheet1'!G15,"Email To Collection Agency")

Sheet1G15 has the data I want to show in the subject line.

Is it possible to do this with Macros? I am using Lotus Notes for email.

Thanks

Igbert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro: VBA code to move/forward email based on subjects and attachments 0
hyperlink with cell info in subject line 0
Excel Macro to creat & send email 2
Macro to send email with multiple attachment 0
email hyperlink - cell value in subject line 12
Email Excel Cell Range using Macro 2
How to send an email from Word using VBA without a routing slip 0
macro to send email 2

Top