[mso] Re: E-mail merge using Access and Word

  • From: Cherie <msogroup@xxxxxxxxxxx>
  • To: mso@xxxxxxxxxxxxx
  • Date: Sun, 30 May 2004 18:52:36 -0400

Does anyone know where I can go to get this question answered?
Does Microsoft have a hot line?
help ..please
C

It was 5/29/2004 when Cherie mentioned:
----------------------Begin Quote------------------------
 >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
 >*************************************************************
----------------------End Quote------------------------ 

*************************************************************
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
*************************************************************

Other related posts: