Electronic mailing list via MS Access?

[Moh]

If you had a list of users in a database in Access who accepted to receive a news letters from 3rd party company's, how would you give the company's the data by creating a mailing list?

Do I export the emails to excel?
Do I simply create a report and send them a paper based version?

Help pls xD

[Jordy]

I might of got you wrong but you could try a Mail Merge in MS Word, it allows you to import the Access database, you could then try email it from within MS Word which I suspect would work.

[Moh]

I might of got you wrong but you could try a Mail Merge in MS Word, it allows you to import the Access database, you could then try email it from within MS Word which I suspect would work.

I was thinking about Mail Merge, but thats more for Letters.

From the assignement *written by Edexel*


The Marketing Department at eRadio MXFM is keen to use this registration as a means of gathering useful information from its listeners. One of the aims is to provide third-party companies with the email addresses of those listeners who want to be contacted about products and services that meet their musical interests. In particular, the department wants to put some specialist music magazines in touch with potential listeners. The music magazines have agreed to pay eRadio for the purchase of listener mailing lists.

Then it says in implementation:


• Produce mailing lists for JazzMaga and PopMaga.

I mean, Edexel could be a little birt more specific. All their assignments are poorly written.

lol, and for a example test exam for Projects, they did the PERT chart wrong so it was impossible to complete.

I hate Edexel :(

[Jordy]

There's a setting to use it for emails rather than word documents within MS Word. Just tested the mail merge with an Access database and it works well. Once completed, open Outlook and it sends the emails.

[Moh]

There's a setting to use it for emails rather than word documents within MS Word. Just tested the mail merge with an Access database and it works well. Once completed, open Outlook and it sends the emails.

I don't think im suppose to be sending the emails, im just suppose to be providing them with the list :S

The database they want is well poor. Heres what happens:

1. Someone fills in a register form for a forum, which is then sent to the ISPs.
2. The ISP then sends a csv file to this internet radio station.
3. Import this csv file into a table
4. Then use an append query to put that data into ANOTHER table.
5. Accept each one individually
6. Export the new data into Excel ready to upload to the site

What aload of crap.

I mean, the course is to use IT how it would in a business, a business would NEVER do that.