Peter wrote: "First of all, don't get nervous... hahaha, I'm pretty sure anything that = Eudora does Outlook can do too,,, maybe even better." Well, not in THIS universe! I'm an ex Eudora user who now uses Outlook, and not a day goes by that I don't miss Eudora. If you want to see rules done properly, look at the way Eudora handles them. And if you want to see something fantastic that Outlook just can't do, check out 'turbo redirect'. Cool isn't the word. The only good reason for switching to Outlook is for integration with the contact manager and scheduler. Most days it's worth it. Ray ------------------------------------ GR Business Process Solutions Ray Blake Head of Software Design ray@xxxxxxxxx Braedon Newell Road Hemel Hempstead Herts HP3 9PD tel: 01442 396518 fax: 01442 389353 www.grbps.com ------------------------------------ -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Peter Chiavaro Sent: 31 May 2004 13:53 To: mso@xxxxxxxxxxxxx Subject: [mso] Re: E-mail merge using Access and Word Hi Cherie and the group. Since nobody jumped in over the weekend, I'll try to help out. I'm not = real good with Outlook but I do know a little Access. First of all, don't get nervous... hahaha, I'm pretty sure anything that = Eudora does Outlook can do too,,, maybe even better. I have some questions: What exactly are you trying to achieve? Can you just explain what you = would like for an end result? I'm loosing you at the part where you have 2 or more addresses for a = student. This might be a "relational" task and I think that Access is = best equipped to handle it. If you're not keeping any data on the Mom's = and Dad's, then, your method of "second Email", third Email" for the = same student should work fine. I am guessing that you'd like to send an Email ONLY to the student's = "primary" Email address and NOT the Mom's and Dad's. Is that correct? In = any case, WHATEVER job you come up with, Access can handle it. Also be = reminded that Access has a field you can set as a "hyperlink". Great for = sending individual emails.=20 It also sounds like using 5 different programs to send one Email is too = much work. I dono for sure, but... I just "sounds like"... there aughta = be a better way. Word, Excel, Access, Outlook (Eudora)... cheesh? Since your data is ALREADY in MS Access,,, the "very best way" would be = to compose AND send the emails directly from within MS Access. Not many = people know it, but MS Access CAN send Email. It can be done but this = requires extensive coding. I have a great MS Access "Bulk Mailer" that = would suit your needs perfectly. Open Access, type the message, and = click one button and off they go. It will run all day and night long no = matter how many thousands of Email addresses you give it. These are = "individual" emails and not one message sent as a carbon copy. At the other end of the spectrum there IS something you can handle, you = can simply have Access output the "precise" list of addresses, then have = Outlook read or import the file. For that, you'll need an "Outlook Person" to jump in here. Careful Are you sending these as "Carbon Copies" through Outlook? If so, then = the people receiving the Emails see a HUGE header with everyone else's = address in it. This is an invite for mischief. If you get one little = brat to grab your list of addresses..... hahahaha,, they could have some = "really cool" fun! Hahaha.. Another way out: If it is strictly announcements you are sending out.. How about just = setting up a mailing list? Freelists, Yahoo, Smart groups... whatever?? = I am not sure if you need replies from the Email you send, or if you = would like to have the students interact with each other. Hope I didn't confuse the issue.. hahaha. Enjoy the holiday. Peter C. Stuart, FL -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On = Behalf Of Cherie Sent: Saturday, May 29, 2004 12:18 AM To: mso@xxxxxxxxxxxxx Subject: [mso] E-mail merge using Access and Word I am the administrator of an email list at a middle school. We can not use an online mail manager because we can only sub people who have students in the school..therefore I have a list of students that = are pulled in from the county records into excel, then Access. this is the way we are doing it next year (using outlook 2002/xp, word 2002/xp, access2002/xp) : all students names, id numbers, grade, email (if any) is put in Access. We start a letter in word..using the mail merge with email (so far, so = good) the last step we pick the email field (duh) to mail to...(so far, so = good) some students have more than one email address (one for mom, one for = dad, etc.) so I wanted to make a second field called 2nd email..which would have worked..but we would have to send the message out twice (first time for email, second for 2nd email) then I thought..hey..I'll put ALL email addresses in the ONE email field separated by a comma and send like that.. well..it works flawlessly from home..using Eudora so I go to work where we are forced to use Outlook Exchange..I can not = for the life of me send it out ..This is what happens: On first send using comma to separate the addresses in the address field (which works fine at home using Eudora)..I get this message: Microsoft Outlook does not recognize "emailaddress@xxxxxxxxx, otheraddress@xxxxxxxxxxxxxx". "if you used a comma to separate several addresses; click cancel and = change the commas to semicolons and try to send again" So I change it to semicolon NO Space and I get: Microsoft Outlook does not recognize "emailaddress@xxxxxxxxx;otheraddress@xxxxxxxxxxxxxx". So I change it to semicolon SPACE and I get: Microsoft Outlook does not recognize "emailaddress@xxxxxxxxx; otheraddress@xxxxxxxxxxxxxx". I put the semicolon on the end of the second address..same thing Seems like it WANTS semicolons as opposed to commas..but I don't know = what format (space, no space, both addresses, one address)...grrrrrrrrr What does outlook want?? (outlook 2002/xp, word 2002/xp, access2002/xp) ---Thanks, Cherie ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx = or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the = quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will = also allow you to change your email settings to digest or vacation (no = mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, = send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an = invitation with instructions. Once you are a member of the files group, = you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************=20 ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************