generalnewbie Posted September 7, 2003 Share Posted September 7, 2003 Hey people.. ok i need your help asap.. ive searched google and nothing really came up.. so i come here.. for some help my problem is i have to create a database.. in access or excel doesnt matter and then.. Send An Email to all the users in the database Now it doesnt matter what i use but i was wanting to make it professional by like having it greet the usersname in the email as well like Dear ..... so and so.. not sure.. how to do this with access or excel but i know it can be done. so any helpful information would be great! Link to comment Share on other sites More sharing options...
ericnmu Posted September 8, 2003 Share Posted September 8, 2003 I'm not too sure either... but maybe this will be a point in the right direction... If you are using excel or access, whice are both microsoft, try using something within outlook 2002. I'll do some research on this in a few, and maybe I can come up with an answer. Link to comment Share on other sites More sharing options...
ericnmu Posted September 8, 2003 Share Posted September 8, 2003 Found a few things... Is the databese of emails grouped together? If so you can go to File Sent to mail recipient, then select the group and paset it in the address field. You will be left with an outlook type email option. Link to comment Share on other sites More sharing options...
MagneticDave Posted September 8, 2003 Share Posted September 8, 2003 Good Morning, I am the database administrator for my company and have a couple of potential solutions for you. 1. To create and send a large number of eMails at once. Create a database with the following text fields: eMail, FirstName, and LastName (plus whatever other info you wish to store). Create a query that selects only the Name and Email fields that you want to use. Save that query, right click on it, and select 'Export...' Save as type 'Text File'. This will save just the name and eMail data as a text file. Now you will need an eMail software. I can recommend Group Mail from Infacta, which you can download a free copy from www.infacta.com. In that program you first create the body of the email on the 'Edit Message' tab. Then you import the text file you just created from Access on the 'Group Manager' tab, Import button. The send button is in the lower right corner of the 'Edit Message' tab. This will create an individual eMail and send them one at a time automatically. Inserted fields will look like !*FIRST_NAME*! It will send several hundred eMails in a matter of seconds, and once you are familier with Group Mail, you could use it for all sorts of mass mails like Christmas newsletters, jokes, or any other newsletter you want to personallize. 2. To create individual e-mails 'en-masse' to send one at a time. Create a database with the following text fields: eMail, FirstName, and LastName (plus whatever other info you wish to store). Save and close the database. Open Microsoft Word, from the Tools menu, select ''Mail Merge". Follow the steps in the wizard to create a 'Form Letter'. You will get the data source by browsing to the Access database. Select the Name and eMail fields you want, and type up the body of the letter. This will create ONE document with personalized eMails to each person on your list. You can cut and paste these into emails and send them one at a time. This is tedious, but does not require any additional software. Hope this helps. MagneticDave Link to comment Share on other sites More sharing options...
generalnewbie Posted September 9, 2003 Author Share Posted September 9, 2003 thanks a million! for the advice i will probably do just that for temp usesage i went ahead and added a new group list in outlook and was gonna make it carbon copys of the emails to that group list that will work also.. Link to comment Share on other sites More sharing options...
Recommended Posts