VBA e-mailing

[zz12]

Hello, this seems pretty simple but for some strange reason and am stumped.
I currently have some vba code behind a startup form in Access that (I
scheduled in the Windows Control Panel 'Scheduled Tasks') that e-mails to a
bunch of e-mail addresses some simple generic written content using
CDONTS.NewMail. It e-mails successfully when putting in just my e-mail
address in the 'To' field value for testing but when changing the code to
all of the intended recipient addresses nothing happens and noone receives
anything. The only thing I can think of as of this moment is when I checked
the '...Mailroot\Drop\' directory on that server I notice a bunch of .eml
files that lists 'Delivery Status Notification (Failure)' as the Subject
field listing the undeliverable e-mail addresses. So I removed these
supposedly underliverable e-mail addresses from the vba code and it still
doesn't complete the e-mail process. But when changing it back to just my
e-mail for testing it works. Any suggesstions?

Thanks in advance.

 

[Alex Dybenko]

Try to resend such dropped message manually, perhaps you have extra char or
space in email address. Also your smtp server should say why email was not
delivered

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[zz12]

Thanks for your reply Alex, appreciate it.


Here's what one of the '.eml' files that's in the '...Mailroot\Drop\' folder
contains:

[This is an automatically generated Delivery Status Notification.
Delivery to the following recipients failed.]

with a .dat attachment that mentions [...Action: failed Status: 5.1.3] when
opening through NotePad:

Is it possible to have hypothetically one underliverable email address that
prevents the entire message being sent to the other valid email addresses?

 

[Alex Dybenko]

Hi,
but are you sure that your smtp server really works then? Check that is
actually allows relay

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Thanks for your reply Alex, appreciate it.


Here's what one of the '.eml' files that's in the '...Mailroot\Drop\'
folder contains:

[This is an automatically generated Delivery Status Notification.
Delivery to the following recipients failed.]

with a .dat attachment that mentions [...Action: failed Status: 5.1.3]
when opening through NotePad:

Is it possible to have hypothetically one underliverable email address
that prevents the entire message being sent to the other valid email
addresses?

Try to resend such dropped message manually, perhaps you have extra char
or space in email address. Also your smtp server should say why email was
not delivered

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[zz12]

Thanks for your effort on this Alex, really appreciate it.

I know for sure it's capable of emailing because I just did another test
with the same code and everything except I used just my email address and
that I do see it in my inbox. But when adding a bunch of the other e-mail
addresses to the "To", "Cc", and "Bcc" fields it doesn't succeed. Still
scratching my head?

Hi,
but are you sure that your smtp server really works then? Check that is
actually allows relay

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Thanks for your reply Alex, appreciate it.


Here's what one of the '.eml' files that's in the '...Mailroot\Drop\'
folder contains:

[This is an automatically generated Delivery Status Notification.
Delivery to the following recipients failed.]

with a .dat attachment that mentions [...Action: failed Status: 5.1.3]
when opening through NotePad:

Is it possible to have hypothetically one underliverable email address
that prevents the entire message being sent to the other valid email
addresses?

Try to resend such dropped message manually, perhaps you have extra char
or space in email address. Also your smtp server should say why email
was not delivered

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


Hello, this seems pretty simple but for some strange reason and am
stumped. I currently have some vba code behind a startup form in Access
that (I scheduled in the Windows Control Panel 'Scheduled Tasks') that
e-mails to a bunch of e-mail addresses some simple generic written
content using CDONTS.NewMail. It e-mails successfully when putting in
just my e-mail address in the 'To' field value for testing but when
changing the code to all of the intended recipient addresses nothing
happens and noone receives anything. The only thing I can think of as
of this moment is when I checked the '...Mailroot\Drop\' directory on
that server I notice a bunch of .eml files that lists 'Delivery Status
Notification (Failure)' as the Subject field listing the undeliverable
e-mail addresses. So I removed these supposedly underliverable e-mail
addresses from the vba code and it still doesn't complete the e-mail
process. But when changing it back to just my e-mail for testing it
works. Any suggesstions?

Thanks in advance.

 

[Alex Dybenko]

Hi,
if you can send to your email address, and not to other, external, then it
something with relay, as relay to own domain is always allowed

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Thanks for your effort on this Alex, really appreciate it.

I know for sure it's capable of emailing because I just did another test
with the same code and everything except I used just my email address and
that I do see it in my inbox. But when adding a bunch of the other e-mail
addresses to the "To", "Cc", and "Bcc" fields it doesn't succeed. Still
scratching my head?

Hi,
but are you sure that your smtp server really works then? Check that is
actually allows relay

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Thanks for your reply Alex, appreciate it.


Here's what one of the '.eml' files that's in the '...Mailroot\Drop\'
folder contains:

[This is an automatically generated Delivery Status Notification.
Delivery to the following recipients failed.]

with a .dat attachment that mentions [...Action: failed Status: 5.1.3]
when opening through NotePad:

Is it possible to have hypothetically one underliverable email address
that prevents the entire message being sent to the other valid email
addresses?


Try to resend such dropped message manually, perhaps you have extra
char or space in email address. Also your smtp server should say why
email was not delivered

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


Hello, this seems pretty simple but for some strange reason and am
stumped. I currently have some vba code behind a startup form in
Access that (I scheduled in the Windows Control Panel 'Scheduled
Tasks') that e-mails to a bunch of e-mail addresses some simple
generic written content using CDONTS.NewMail. It e-mails successfully
when putting in just my e-mail address in the 'To' field value for
testing but when changing the code to all of the intended recipient
addresses nothing happens and noone receives anything. The only thing
I can think of as of this moment is when I checked the
'...Mailroot\Drop\' directory on that server I notice a bunch of .eml
files that lists 'Delivery Status Notification (Failure)' as the
Subject field listing the undeliverable e-mail addresses. So I
removed these supposedly underliverable e-mail addresses from the vba
code and it still doesn't complete the e-mail process. But when
changing it back to just my e-mail for testing it works. Any
suggesstions?

Thanks in advance.

 

[zz12]

Thanks Alex, that does probably make sense and will look into it further
also.

I ran the process again and it's a bit strange now in that there was only 1
'.eml' file listed in the '...\Mailroot\Drop\' folder that mentions only one
of the intended recipient e-mail addresses that the Delivery Status failed.
But in looking at the '...\Mailroot\Queue\' folder there is 1 '.eml' file
which when I open it up is the entire full e-mail message with all of the
included intended e-mail addresses as is. I wonder why my coded e-mail
message is sitting in this Queue folder and not being sent out?

Hi,
if you can send to your email address, and not to other, external, then it
something with relay, as relay to own domain is always allowed

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Thanks for your effort on this Alex, really appreciate it.

I know for sure it's capable of emailing because I just did another test
with the same code and everything except I used just my email address and
that I do see it in my inbox. But when adding a bunch of the other
e-mail addresses to the "To", "Cc", and "Bcc" fields it doesn't succeed.
Still scratching my head?

Hi,
but are you sure that your smtp server really works then? Check that is
actually allows relay

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Thanks for your reply Alex, appreciate it.


Here's what one of the '.eml' files that's in the '...Mailroot\Drop\'
folder contains:

[This is an automatically generated Delivery Status
Notification. Delivery to the following recipients failed.]

with a .dat attachment that mentions [...Action: failed Status: 5.1.3]
when opening through NotePad:

Is it possible to have hypothetically one underliverable email address
that prevents the entire message being sent to the other valid email
addresses?


Try to resend such dropped message manually, perhaps you have extra
char or space in email address. Also your smtp server should say why
email was not delivered

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


Hello, this seems pretty simple but for some strange reason and am
stumped. I currently have some vba code behind a startup form in
Access that (I scheduled in the Windows Control Panel 'Scheduled
Tasks') that e-mails to a bunch of e-mail addresses some simple
generic written content using CDONTS.NewMail. It e-mails
successfully when putting in just my e-mail address in the 'To' field
value for testing but when changing the code to all of the intended
recipient addresses nothing happens and noone receives anything. The
only thing I can think of as of this moment is when I checked the
'...Mailroot\Drop\' directory on that server I notice a bunch of
.eml files that lists 'Delivery Status Notification (Failure)' as the
Subject field listing the undeliverable e-mail addresses. So I
removed these supposedly underliverable e-mail addresses from the vba
code and it still doesn't complete the e-mail process. But when
changing it back to just my e-mail for testing it works. Any
suggesstions?

Thanks in advance.

 

[zz12]

Finally figured it out. I guess our other higher up department that
administrates the main overall mail required the 'Smart host' field be added
to our local smtp server. I did this and it now works. Thanks Alex for
your replies as it seemed the solution was the direction you advised, much
appreciated. Take cares

Thanks Alex, that does probably make sense and will look into it further
also.

I ran the process again and it's a bit strange now in that there was only
1 '.eml' file listed in the '...\Mailroot\Drop\' folder that mentions only
one of the intended recipient e-mail addresses that the Delivery Status
failed. But in looking at the '...\Mailroot\Queue\' folder there is 1
'.eml' file which when I open it up is the entire full e-mail message with
all of the included intended e-mail addresses as is. I wonder why my
coded e-mail message is sitting in this Queue folder and not being sent
out?

Hi,
if you can send to your email address, and not to other, external, then
it something with relay, as relay to own domain is always allowed

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Thanks for your effort on this Alex, really appreciate it.

I know for sure it's capable of emailing because I just did another test
with the same code and everything except I used just my email address
and that I do see it in my inbox. But when adding a bunch of the other
e-mail addresses to the "To", "Cc", and "Bcc" fields it doesn't succeed.
Still scratching my head?



Hi,
but are you sure that your smtp server really works then? Check that is
actually allows relay

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Thanks for your reply Alex, appreciate it.


Here's what one of the '.eml' files that's in the '...Mailroot\Drop\'
folder contains:

[This is an automatically generated Delivery Status
Notification. Delivery to the following recipients failed.]

with a .dat attachment that mentions [...Action: failed Status: 5.1.3]
when opening through NotePad:

Is it possible to have hypothetically one underliverable email address
that prevents the entire message being sent to the other valid email
addresses?


Try to resend such dropped message manually, perhaps you have extra
char or space in email address. Also your smtp server should say why
email was not delivered

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


Hello, this seems pretty simple but for some strange reason and am
stumped. I currently have some vba code behind a startup form in
Access that (I scheduled in the Windows Control Panel 'Scheduled
Tasks') that e-mails to a bunch of e-mail addresses some simple
generic written content using CDONTS.NewMail. It e-mails
successfully when putting in just my e-mail address in the 'To'
field value for testing but when changing the code to all of the
intended recipient addresses nothing happens and noone receives
anything. The only thing I can think of as of this moment is when I
checked the '...Mailroot\Drop\' directory on that server I notice a
bunch of .eml files that lists 'Delivery Status Notification
(Failure)' as the Subject field listing the undeliverable e-mail
addresses. So I removed these supposedly underliverable e-mail
addresses from the vba code and it still doesn't complete the e-mail
process. But when changing it back to just my e-mail for testing it
works. Any suggesstions?

Thanks in advance.