[mso] Re: E-mail merge using Access and Word :VSMail mx5
- From: James LaBorde <jlaborde@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Tue, 1 Jun 2004 11:31:44 -0700
Cherie,
I didn't see your stated desire to keep a single record per student in the
database. (This would be where relational of relational database can help
you but we will get around that).
While the MakeTable/Append Table option will work, it will also lead to
database bloat. With the size of your database already up there, you will
want to avoid that. Two recommendations here. First, make sure you compact
your database regularly and keep a good backup copy at all times. Second,
consider using a Union Query. A union query simply takes two queries and
combines them into one.
Here is what you will want to do:
Create a query listing all of the fields you want with email1 as an Email
Address (Make sure to give it an alias, this will become important later, ie
EmailAdd: [email1]). Save this query.
Create your second query with all the same fields from the first step but
substituting email2 for email1. (Make sure your alias is exactly the same.
Save this query.
Open a new query and click on View, SQL, minimize this window
Open your first query in design mode and click View, SQL. Highlight
everything you see and copy (right-click copy or ctrl C). Close this query.
Bring your empty query back up and paste your data in there. Delete the
semicolon at the end of the string. Next click enter to advance one line
and type UNION. Minimize this query
Open your second query in design mode and repeat the process of copying the
sql code for it from above.
Bring back your Query in progress and paste the new data starting in the
line after your Union
Save the new query. Execute it and you should get a resultset that lists
all the data you need for your mail merge.
If you need more help, feel free to drop a line.
James La Borde
-----Original Message-----
From: Cherie [mailto:msogroup@xxxxxxxxxxx]
Sent: Monday, May 31, 2004 4:25 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: E-mail merge using Access and Word :VSMail mx5
Forgot to mention in that long reply..that my ultimate goal is EACH student
have only ONE record
until I figure out how to put two (or more ) email addresses in the ONE
email field and have it work using outhouse..I have made duplicate records
for students that have more than one email address..this avoids having to
send a merge twice (once for email1, then for email2)..but it creates a
false count for how many students are signed up.
thanks
Cherie
---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
*************************************************************
*************************************************************
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:
