View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Email with mailto equivalent

I am not sure whether I have understood your question...Please elaborate your
query if you are looking for something else.

strToIDs = Combine(ARRAY,";")
strSubject = "------------------"

With OutMail
.To = strToIDs
.CC = ""
.BCC = ""
.Subject = strSubject
.Body = "Hi there"
.Attachments.Add ("C:\test.txt")
.Send
End With

If this post helps click Yes
---------------
Jacob Skaria


"elf27" wrote:

Hello,

I've searched the forums and reviewed http://www.rondebruin.nl but I can't
seem to find an answer to a simple question.

I want a macro to email persons in a range and have a custom subject line
but I do not rely on them using outlook. If it's possible, I'd basically like
the equivalent of

mailto:[ARRAY]?subject=Item [VARIABLE X] Posted Online

Any way to do that?