[mso] Re: E-mail merge using Access and Word
- From: Cherie <msogroup@xxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 01 Jun 2004 14:42:44 -0400
It was 6/1/2004 when Peter Chiavaro mentioned:
----------------------Begin Quote------------------------
>Now I can see that it's not right. [snip the talking with hands] but
somehow I get the feeling that you might =
>like to get the thing RIGHT from the beginning. (while it's still
REALeasy to fix)
YES..I want it right ..you are correct
>ID:
>Is the ID field alphanumeric (letters and numbers)? And I think you =
>mentioned the County generated this ID?
NUMBERS..yes county generates the number when the child enters
Kindergarten..the number stays with them as long as they are in public
school in Florida
Of course you can store this value in your database, but it should be
stored in a field named =
>"CountyID", and used only for reference.
I have named the field as StudentID (no spaces..I HATE spaces..NEVER,
NEVER, NEVER use them..can you believe I work with teachers who actually
name their files stuff like "letter to mrs. brown about tommy's
behavior.doc" ????!!!!! and I originally wanted the StudentID to be the
primary key..but it wouldn't work..when I imported the stuff from excel..I
must of had a duplicate or two of student ID numbers...and I also wanted a
relationship between student name and student ID..but kept getting an error
message saying it could not be done..don't remember the exact message
You'll ALSO need a field named "StudentID". This field should be an
"AutoNumber" field that =
>automatically increments itself by one every time you add a new student.
I have this named as ID..it was the primary key that Access created..this
ok so far??
>This field will generate a unique ID number in order to do your =
>"relational" look-ups inside the database. This may be the reason you =
>are not understanding "relationships".
I understand them..sorta..I just kept getting a message about something not
being unique and I could not find the problem..
>database, the programmers like to see one word names with a little =
>prefix. Like this: "tblStudents", "fldCountyID", "qryAnyQureyName", =
>"rptAnyReportName", and so on.
this is the way I was taught in the two trainings...I like the idea..it
comes in handy and I have been using names like qry-8thGrade, qry-All,
qry-7thGrade, etc.
>I am not too fond of the way you have your "Name" field set up either. =
>If you want to use one field for the name, then it absolutely has to be =
>in "LastName, FirstName, MiddleInitial, Suffix (if any) format.
because I don't have the database in front of me right now...I am not
positive..but I'm pretty sure I have it set up as LastName, FirstName
(don't need middle initial....yet)..and I think the field name is StudentName
I think you mentioned =
>you have until August to get it running. For right now, there should =
>STILL be a way to extract the exact Email addresses you want, should you =
>need to output TODAY, but... I really think you should fix up your field =
>types and field names, and also your ID fields; otherwise you'll be just =
>spinning your wheels.
OK..from what I have described above..are they fixed??
Ultimately I will need your Email address so I can =
>send you the little example picture database and the bulk mailer thing.
this one will work :o)
=
>Maybe we'll take a shot at setting that up as well. I'm sure the =
>principal would like to compose the Email and click one button... POOF,, =
>send 500 emails. We can make that our goal.
yeah..and I'll be the hero for the day too
>My Email is:
>kp@xxxxxxxx
I know..I think I privately emailed you something already... :o)
>Have a nice day.
you too..thanks
Cherie
----------------------End Quote------------------------
---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
*************************************************************
Other related posts:
