Issue with Mass-Email VBA macro

[MikeSta4ord]

Hello,

I'm having trouble getting my macro to effectively send a mass email which is based on a message template set up in excel. The code I am attempting is:

Please Login or Register  to view this content.

It's not giving me a particular error but nothing is happening after I execute the macro. So I suppose I am missing something within the code for it to execute correctly. It is also supposed to be deleting the data in the email tab when it sends out the email.
I will attach a sample file to show you the excel file I am working with. You have to input an email address to test the macro on yourself. Please let me know if you need anything else from me.

Thank-You very much
Mike

[pjwhitfield]

Unfortunatley I dont have Outlook so cant test this but what happens when you debug? where does it drop out?

[jaslake]

Hi Mike

The Code appears to work for me.

Change the indicated line of Code then run the Workbook Open Code again...get anything?

Please Login or Register  to view this content.

[MikeSta4ord]

It doesn't appear to be dropping out anywhere, It just isn't sending off the email for some reason

[MikeSta4ord]

John,

After running the code with the change I get a display of the email. It appears to be working but I need the macro to actually send the email so is there something else to use for olmail.send?

[jaslake]

Hi Mike

If I place my Email Address in Cell D2 and change the Code

Please Login or Register  to view this content.

The Email Sends and I receive it.

[jaslake]

Hi Mike

You're running the Code on Workbook Open (I guess I'd ask why)...place email addresses in Column D, save and close the file. Open the File..what happens?

[pjwhitfield]

Im going to ask a really dumb question and I know the answer is yes but you do have an actual email account set up in Outlook dont you?

[MikeSta4ord]

John, I want it to run when the workbook opens because the data fills in the email tab when a certain date is reached. When I open the workbook nothing at all happens, even after trying to run the macro on its own it doesn't do anything...It just runs without an error but i don't receive an email. Sorry I'm truly not familiar with VBA, I'm trying to do my best to explain the issue.

Yes Pj, I do have an outlook email account. This code worked for me before, but after I made a minor change to the cells it referenced on a newly installed office 16, it stopped working. Wondering if there is an issue with the settings within office 16.

[jaslake]

I've tested the Code in both Excel 2007 and 2010 and it performs as expected. I'll ask others that have Excel 2016 to test for you.

http://www.excelforum.com/showthread...50#post4371150Hi Mike

[pjwhitfield]

What version of Outlook are you using?

[MikeSta4ord]

outlook 2016

[MikeSta4ord]

I've identified the issue. Like you suggested, it wasn't with the macro. The issue was with the outlook server I was connected to, the outbound server was incorrect and that was giving me the issue of not sending out emails.

Thanks for your help.

[jaslake]

Glad you got it sorted.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.