Question Mass Email with Access - How to get around the Security

[txgeekgirl]

We have a DB that we host on a machine by itself with an older copy of Access so that it can use an older Library for mass email report send outs via Outlook->Exchange to our EUs. The emails have attach. which are txt files.

My problem. I need the Server O/S off my current server for my new blade and want to move that DB to my new blade but have to find a get around for the email problem. I would like to move all my Access DBs to this new blade and all run on 2003 except this one because I can't get around the Outlook warning system where it physically wants you to verify auto gen email.

If anyone has ANY recommendations, I sure would appreciate it.

I have heard of a command line email that can be issued into exchange but cannot find a program name.

 

[wazz]

i don't know if this will work for your situation but take a look at Outlook Redemption (should be at or near the top of Google search). it works well.

 

[statsman]

Talk to some of the people who are selling IPhones and the like on this forum.

They don't seem to have any trouble getting around the security.

 

[Uncle Gizmo]

The other issue to be aware of (I suspect it may not apply in your particular case) is if you start sending out mass emails you may be flagged as a “Spammer” and this could result in restrictions or other measures being imposed on you and your ability to e-mail.

 

[NigelShaw]

As far as I'm aware, mass emailing ( especially the iPhone guys here ) would use a simple php mailer. I have one on a website for members.

I do have a db I made though that will mass email through outlook using access.

It checks for outlook. If you have it, it will open it and send the mails.

There are various ways to do it without the security, you just need to find them.


Nidge

 

[dbDamo]

Use CDO. Install it under Outlook from add or remove programs. Here is the code I am currently using.

Dim mydb As DAO.Database
Dim rs As DAO.Recordset
Set mydb = CurrentDb()
Set rs = mydb.OpenRecordset("6g daily email query", dbOpenSnapshot)
With rs
.MoveFirst
Do Until rs.EOF
If IsNull(rs.Fields(0)) = False Then
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "Todays Testing for " & rs.Fields(1)
objMessage.From = "Project Testing <[EMAIL="bwbsl.testing@bwbsl.co.uk"]bwbsl.testing@bwbsl.co.uk[/EMAIL]>"
objMessage.Sender = "Project Testing <[EMAIL="bwbsl.testing@bwbsl.co.uk"]bwbsl.testing@bwbsl.co.uk[/EMAIL]>"
objMessage.To = rs.Fields(0)
objMessage.TextBody = "Below is a listing of testing work for you Today. If you need a detailed listing of tests, please contact the Testing Team who will provide this.  " & vbCrLf & _
                    "Number of Tests Due to Complete Today: " & rs.Fields(2) & vbCrLf & _
                    "Number of Tests Due to Start Today: " & rs.Fields(3) & vbCrLf & _
                    "Number of Tests Past Planned Completion Date: " & rs.Fields(4) & vbCrLf & _
                    "Number of Tests Past Planned Start Date: " & rs.Fields(5) & vbCrLf & _
                    "Number of Tests Due to Start Tomorrow Prep Not Complete: " & rs.Fields(6)


objMessage.Configuration.Fields.Item _
("[URL="http://schemas.microsoft.com/cdo/configuration/sendusing"]http://schemas.microsoft.com/cdo/con...tion/sendusing[/URL]") = 2

objMessage.Configuration.Fields.Item _
("[URL="http://schemas.microsoft.com/cdo/configuration/smtpserver"]http://schemas.microsoft.com/cdo/con...ion/smtpserver[/URL]") = "smtp.server.com"

objMessage.Configuration.Fields.Item _
("[URL="http://schemas.microsoft.com/cdo/configuration/smtpserverport"]http://schemas.microsoft.com/cdo/con...smtpserverport[/URL]") = 25
objMessage.Configuration.Fields.Update

objMessage.Send
End If
.MoveNext
Loop
End With
rs.Close
Set mydb = Nothing
Set rs = Nothing

 

[Simon_MT]

The question of whether or not you are spamming is not the issue. What you can do is to use SMTP and circumvent Outlook completely. You need to get IIS installed and each PC and configure your SMTP to the appropriate Server.

Simon

 

[NigelShaw]

Hi

I didn't think iis was a requirement for smtp based email. Smtp is only a setting from your service provider which you place in your code anyway.

I use a smtp on my laptop.


Nidge

 

[txgeekgirl]

Just wanted to let you know that I used this... http://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-Without-Security-Warning

It does modify fairly easy and work. The only downside is that if you are running a couple of DBs that need to use the code, and you are using terminal services, the Outlook portion has to be on every email login for your users. You can't push out but have to manually install one time for them.

BTW - not a spammer. We get reports from the State computers that come innightly, hit our system, and get auto-forwarded to our department heads via an Access DB so that we don't have a secretary somewhere having to figure out who gets what.

I would love to see spammers eventually treated as I would like rapists, murderers and pedophiles - shot in the head clean, one time.

 

[darkstar257]

Just wanted to let you know that I used this... http://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-Without-Security-Warning

It does modify fairly easy and work. The only downside is that if you are running a couple of DBs that need to use the code, and you are using terminal services, the Outlook portion has to be on every email login for your users. You can't push out but have to manually install one time for them.

BTW - not a spammer. We get reports from the State computers that come innightly, hit our system, and get auto-forwarded to our department heads via an Access DB so that we don't have a secretary somewhere having to figure out who gets what.

I would love to see spammers eventually treated as I would like rapists, murderers and pedophiles - shot in the head clean, one time.

I've implemented this method before but decided to not use it due to two reasons.

1. I would have to insert a macro code on every user computer in the company and change their macro security settings
2. It wasn't complete 100% successful. Sometimes Outlook would simply forget I had allowed this code to run and just doesn't let it pass through and a second later it will with nothing changed

 

[GaryPanic]

This is interesting - I am thinking about mass email solution to a problem I may come across
I am in insurance and some of our policies are low premium ..£30.-£50 policies anyway there are 10,000 of them
I can easliy do a mail merge with what I need to do - (simples )
but will hit costs due to postage - (also trying to be greener - lost postal mail less carbon miles - less paper etc

would this be the route to take ?

 

[Simon_MT]

I would still opt for the SMTP route, it only needs IIS and it compents to be loaded. The advatage if that there is some control over who does the mailing, aviods sending the same information twice.

The other downside of using Outlook if I remember correctly is all these email end up in a Outlook folder and that can be inconvenient.

Simon

The other caveat is that some ISP's limit the number of emails sent so you have to have a fairly flexible ISP.

 

[Kryst51]

This is interesting - I am thinking about mass email solution to a problem I may come across
I am in insurance and some of our policies are low premium ..£30.-£50 policies anyway there are 10,000 of them
I can easliy do a mail merge with what I need to do - (simples )
but will hit costs due to postage - (also trying to be greener - lost postal mail less carbon miles - less paper etc

would this be the route to take ?

Do you have Ofice 2010? You can mail merge with Outlook just like you would with Word.... You can even send your mail merge as an attachement, etc. (I don't say 2007 because I never used it and don't know if that option is available or not.)

 

[Uncle Gizmo]

Very strange this thread should be resurrected just now! I have just completed a project where the customer wanted to send emails from MS Access VBA via Google Mail.