Sending Emails Via Microsoft Access
-
Hi all, My problem comes from one of the users at the company I work for, he has developed a access database which will be used to generate reports instead of them currently using paper and handing it back and forth between departments. He wants them to be able to simply click a button when they are finished and it send an email to the next person in the chains email address. (the email address is just a generic one that everyone will use for this and will be sent to personal company email address) This can be done easily with a macro and outlook but unfortunately my companies ISA Server blocks all POP3, IMAP and HTTP from internal sources to external sources and this cannot be changed, thought HTTPS is allowed. This means Outlook will not allow us to send or set up email accounts on it, annoyingly this seems to be because it cannot bring in emails from the server (which is a gmail server) even though we don't want this feature, we just want to send emails. I have also tried to use Mozilla thunderbird but had the same problem. Any help or ideas would be great. If you need anymore information just ask. Thanks :-D
-
Hi all, My problem comes from one of the users at the company I work for, he has developed a access database which will be used to generate reports instead of them currently using paper and handing it back and forth between departments. He wants them to be able to simply click a button when they are finished and it send an email to the next person in the chains email address. (the email address is just a generic one that everyone will use for this and will be sent to personal company email address) This can be done easily with a macro and outlook but unfortunately my companies ISA Server blocks all POP3, IMAP and HTTP from internal sources to external sources and this cannot be changed, thought HTTPS is allowed. This means Outlook will not allow us to send or set up email accounts on it, annoyingly this seems to be because it cannot bring in emails from the server (which is a gmail server) even though we don't want this feature, we just want to send emails. I have also tried to use Mozilla thunderbird but had the same problem. Any help or ideas would be great. If you need anymore information just ask. Thanks :-D
-
If you have an internal mail server (Exchange, zimbra...), you could use its SMTP service since it should be authorized by ISA Server.
We don't unfortunately all are emails are with Google/Gmail and its all administrated from the company HQ in France. I have thought about setting up an email server but to be honest its not something I have ever done and wouldn't know where to look or start. Thanks for your reply :)
-
We don't unfortunately all are emails are with Google/Gmail and its all administrated from the company HQ in France. I have thought about setting up an email server but to be honest its not something I have ever done and wouldn't know where to look or start. Thanks for your reply :)
You can setup an smtp service easily on a linux box, for instance, but it won't prevent you from asking your sysadmin to open the firewall for this service. Thus I can't see a solution for you, sorry :(
No memory stick has been harmed during establishment of this signature.
-
Hi all, My problem comes from one of the users at the company I work for, he has developed a access database which will be used to generate reports instead of them currently using paper and handing it back and forth between departments. He wants them to be able to simply click a button when they are finished and it send an email to the next person in the chains email address. (the email address is just a generic one that everyone will use for this and will be sent to personal company email address) This can be done easily with a macro and outlook but unfortunately my companies ISA Server blocks all POP3, IMAP and HTTP from internal sources to external sources and this cannot be changed, thought HTTPS is allowed. This means Outlook will not allow us to send or set up email accounts on it, annoyingly this seems to be because it cannot bring in emails from the server (which is a gmail server) even though we don't want this feature, we just want to send emails. I have also tried to use Mozilla thunderbird but had the same problem. Any help or ideas would be great. If you need anymore information just ask. Thanks :-D
If I read correctly, you want to send e-mails but can't because of system limitations. This is not an Access problem. Why not FTP the document to a server, then allow the users to come get it? Send a G-Mail to all users (manual creation, probably) telling them the new report is available for review, click this link, and they can download it from there. Not much you can do, e-mail wise.
Gary