Relative Content

Tag Archive for excelvbaoutlook

Why vba code can not create Outlook application mailItem

Hy
I am trying to send email using MS Outlook 15.0 object library and using VBA codes from host Excel 2013.
When the macro try to create MailItem, the Microsoft demand me to open OutLook 2013 account. Detail: my machine is running Outlook Web.
I ask if this demand is realy necessary.
Is there any solution to this problem?

VBA for transfer emails from Outlook app to excel

I need your help guys if you can. I am new to VBA so I am still learning and my code is probably not powerful but I would like to bring it to life. It works, but in a different way than I expected. I am sharing with you my excel VBA code to receive emails from Outlook. When I start Excel and Outlook and run the vba code I get an error on this line =>

VBA Excel HTMLBody doesn’t work for different values

I want to prepare the automatic email reply based on various values in the column.
I’ve prepared the Case, although it seems like it doesn’t work. Despite no error, nothing is shown in Outlook as the HTMLBody.

Add default signature

everyone!
I’ve been having trouble with a macro I’ve been developing, I tried everything and still haven’t found the answer, hope anyone can help me with this. Here’s my code;