What do you mean by "it generates an error"?Turning off screen updating imply
makes it so that the screen isn't flashing and updating whenever you switch
between sheets or updates values.It doesn't do ANYTHING to handle errors.
"Alerts" is what the messages are that are things like:prompts when r
Hi,
Any update on this? Do I need to run/duplicate this macro for each email?
also strangely If I run the macro, I then start receiving duplicate emails
in my email box, do I need to activate/deactivate something?
Thank you very much in advance,
jorge
On 16 March 2016 at 13:01, Jorge Marques wro
In VBA, you'll need to include the "Microsoft Outlook 14.0 Object Library
"(under Tools->References)
then, this VBA code should work:(use your own email addresses for
"name@domain")---Option Explicit
Sub Test_Mail()
Dim Stat, fso
Dim Mail_Addr_To, Mail_Addr_CC, Mai
Hi Paul,
i have the Microsoft Outlook 15.0 Object Library.
The Macros runs fine if I remove the updates and display alerts, if not it
generates error.
'Application.ScreenUpdating = False
'Application.DisplayAlerts = False
This is great starting point, my challenge now besides the error is how d
Hi Paul,
Yes I use Outlook, Having Outlook opened for it to work is not an issue for
me, it is always open from the moment computer is on until is shut down.
Providing the function would be more than helpful :). Thank you very much!
Best,
Jorge
On 15 March 2016 at 19:15, Paul Schreiner wrote:
First of all, Excel doesn't have email capability.What it DOES do, however, is
allow you to use your existing email software.
At least somewhat.
What email do you use?I use Outlook.With that, I can write a function that
takes the email address and filename as input and creates/sends the appropria
