Hello. I am using Office 2013. I have excel vba working great except for outlook doesn't attach the file 100% of the time. Sometimes it attaches and sometimes it doesn't. It only acts up for remote (out of the office) individuals. The excel macro runs and attaches an email in outlook and saves...
I got this working...but need to combine the two .cc lines. (semail and rok_contacts)
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
Dim xOutLook As Object
Dim xNmae As Object
On Error Resume...
That is correct regarding the rok_contacts.....
ok so I now have....
Dim OutApp As Object
Dim OutMail As Object
Dim myCC As Outlook.Recipient
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
Set myCC =...
Hi Diane.....
So Before:
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.SentOnBehalfOfName = "abc@email.com"
.Display
.To =...
Hello. I am now on my final issue. Thank you!!!!!!
I have the following vb code (attached) and I am trying to add the sender automatically to the .cc line.
the Sender will change so i can't hardcode an email address automatically to the .cc line.
I currently have a specified group on the .cc...
No it doesn't go away. I did move the .display right after the .sentonbehalfofname and it seems to be working now. Now my next question is, I am getting the "This message could not be sent. Try sending the message again later, or contact your network administrator. You do not have the permission...
Hello.
I am using Office 2013. I have a excel file that I run a macro and attaches an attachment in Outlook.
I am using the sent on behalf of name command within the vb. Everything works great. (the email is saved in the drafts folder which I want it to do)
.SentOnBehalfOfName =
But when I...
Hello. I am trying to do the following. Run a macro in Excel which will attach a file in Outlook (Office 2013) and save in the draft folder of a shared department folder. I will then go to the shared department Outlook account, review the email and click send. I need the email when received by...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.