Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to create a mail in which a distribution list is taken from an excel list
Hello
How to create a mail in which a distribution list is taken from an excel list I made something like this.But I need toadd the to list from an excel list located at some location. Is it possible. Also I need to enter the signature from the signature.in my case signature is not working.can some help me Set vOlApp = CreateObject("Outlook.Application") Set Vmessage = vOlApp.CreateItem(olMailItem) Vmessage.Subject = "xxxx" Vmessage.To = " Vmessage.CC = " Vmessage.Body = "Dear All" & vbCrLf & vbCrLf & "Please give me asolution " & vbCrLf & vbCrLf & vbCrLf & vSignature Vmessage.Display |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I easily create an Outlook distribution list from excel? | Excel Discussion (Misc queries) | |||
can i create a distribution list between excel and outlook? | Excel Discussion (Misc queries) | |||
How do I create an Outlook distribution list from an Excel column | Excel Discussion (Misc queries) | |||
Is it possible to create distribution list for Outlook? | Excel Programming | |||
Send mail from vba with the outlook distribution list | Excel Programming |