How to e-mail to groups

[greaseman]

Not sure if this is the right spot, but....
I'm wanting to take a text or excel file of thousands of e-mail addresses and perhaps via MS Access (Version 2003 or 2007, preferably 2007), e-mail messages to these e-mail addresses, but with using different sender names per every, say 1,000 email addresses. In other words, let's say I have 10,000 email addresses. Can I use Access to break this bunch of addreses up into groups of 500, and then for each group of 500, have another file of sender names and attach sender name 1 to the first 500, sender name2 to the next 500, and so on?

Is this more of a VBA question? Does anyone have a sample or example of how this might be done?

Thanks in advance to any and all who reply....looking forward to receiving your responses!

 

[ByteMyzer]

This wouldn't be an attempt to create an MS-Access based SPAM-bot, of some kind, now would it?

 

[greaseman]

No, no attempt to create a spam-bot....if it was, there's much better software out there for that purpose. Why would I take the time to create a database of ids and then use Access for that purpose? I'm a reputable professional, working at a reputable organization.

I work at a college that has several campuses with about 70,000 students. This is an attempt to automate e-mail messages to the students from a group of advisors - to try to automate something that the advisors are currently doing manually.

If anyone has an idea or two, or even better, an example or two, I'd love to hear from you. Thanks in advance.

 

[ajetrumpet]

I'll chime in here: this is too difficult to do.

 

[greaseman]

Why is this too difficult to do??

Please explain your reply...... thanks.

 

[ajetrumpet]

I simply meant that I don't want to spend the time to figure it out. Just kidding with u of course, but I really don't have time today. But I do know that you could do this yourself pretty easily if you know how to use the right words to search google. That's where I get ALL of my answers.

 

[Darth Vodka]

I work at a college that has several campuses with about 70,000 students. This is an attempt to automate e-mail messages to the students from a group of advisors - to try to automate something that the advisors are currently doing manually.
.

set them up on a yahoogroup

www.yahoogroups.com

they can join/leave as they like and you can add them all in as admin

 

[GaryPanic]

set them up in Outlook and create news groups

 

[greaseman]

I think this posting is getting off the track.... I want to be able to do this in MS Access, so that the process is fairly automatic and transparent to the client. In addition, this is for a college, with approximately 70,000 students. And, these students are already set up in Outlook, but by an E_Mail administrator.

What I want to be able to do for my client is to automate the sending of a start-of-semester message to these students.... just have a text file that feeds into MS Access and using some VBA code, grab just a few thousand students and send them an E_Mail that looks like it comes from a counselor.

I don't htink Newsgroups is the answer..... I think that would just be a boit of an extra process or two, when I believe Access can do this. In addition, the student population can change at any given time.... students withdrawing, failing, etc and I don't want to always be managing and updating a bunch of newgroups.

So...... does anyone have an idea of how to do this sort of thing from within MS Access and only from within Access, via Outlook?

 

[GaryPanic]

Well there is a sample d/b that call senator (or something like that )
anfd basically you can select names from a list type in a message in a text box and attach a rft file and send - but i think from memory itr puts all the addess in the to field not 1 at a time

i think what you are asking for - most people will think is a bit iffy -

i have a d/b that will group all the names in the to field and send an attachment - but not one at a time

 

[greaseman]

Actually, at this very moment, there are two examples of e-mail items in the samples section of this forum; I'm going to work with them and see what comes up.

Thanks for your replies, but I think I'm all set for now.

 

[ajetrumpet]

here's where you start: http://www.access-programmers.co.uk/forums/showthread.php?goto=newpost&t=158170

after that, you'll have to code it in order to split the sending action into multiple instances.

 

[greaseman]

Right!.... that's the one I found, that I said I would try and use as my starting-off point. I appreciate your sending the link, although I had already located it.

Thanks for replying and for the sample!

 

[greaseman]

I got it figured out and it's working like a charm.....

 

[Rabbie]

I got it figured out and it's working like a charm.....

Glad to hear you got it working. It would be very helpful if you could post your solution here as an aid for future seekers.