Search results

  1. P

    Outlook Randomly Not attaching (attachment file)

    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...
  2. P

    MS OUTLOOK 2013 - Adding Sender on the CC line

    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...
  3. P

    MS OUTLOOK 2013 - Adding Sender on the CC line

    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 =...
  4. P

    MS OUTLOOK 2013 - Adding Sender on the CC line

    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 =...
  5. P

    MS OUTLOOK 2013 - Adding Sender on the CC line

    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...
  6. P

    MS OFFICE 2013 - Outlook locking up when using the sent on behalf of feature in VB

    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...
  7. P

    MS OFFICE 2013 - Outlook locking up when using the sent on behalf of feature in VB

    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...
  8. P

    Macro to attach a file in a shared Outlook draft folder

    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...
Top