Russ,
Thanks for listening. This is going to be longwinded but it is every
step
I
am taking. BTW I am running outlook and word 2003. I start with
Outlook
open and Word closed.
1. I sort my contact database in outlook by category and highlight the
contacts I wish to mail merge into labels.
2. Once highlighted, I click on the tools tab and click on mail merge.
A
box pops open and the criteria for the mail merge that are highlighted
with a
green bubble are "only selected contacts", "all contact fields", and
"new
document". The choose merge option to mailing labels and I merge to a
new
document then click OK.
3. Word launches and I get a grey bar telling me Outlook has created a
mail
merge.in order to complete the setup you must press the "set up" button
in
section 1 of the mail merge helper dialog. I click OK
4. The Mail Merge Helper Dialog appears with 3 steps. There are main
document, data source, and merge data with document.
5. Step #1 under main document I click create and choose mailing labels
then
choose 5660 labels in the set up.
6. Step #2 under data source I get confused. I have tried every
combination
I can think of and in every case I get weird data where it appears to
put
the
entire contact record including the notes field into one line or I get
no
data at all. If you can walk me in from there I am or tell me what I
am
doing wrong up to this point, that would be great.
Lee
:
It is impossible to walk you through the correct steps for a mail
merge
over
and above the instructions I've already posted. We cannot know enough
about
your setup to do that. I would suggest you post the exact steps you've
used
and what isn't working so we can troubleshoot. This is just a news
group.
We
aren't "reps."
--
Russ Valentine
[MVP-Outlook]
Russ,
I cannot make this work either. Is there a number where I can get
someone
to walk me through my problem? I have tried this forum with 4
different
reps
and have gotten 4 different things to try and still have not made
any
headway.
Lee
:
In Outlook/Word 2002/2003 there is an extra step required to create
mailing
labels. Instructions here:
http://support.microsoft.com/?kbid=284401
--
Russ Valentine
[MVP-Outlook]
Russ,
I have again tried every combination with the mail merge helper
in
Word
but
the only data I can get is "New Record" in every label space and
a
2nd
Word
ducument with the following type of data. This data represents
information
within the contact but all I want is the mailing address in a
label?
If you could walk me through the set up in the mail merge helper
that
would
be great.
"Account","Anniversary","Assistant's Name","Assistant's
Phone","Billing
Information","Birthday","Business Address","Business Address
City","Business
Address Country","Business Address PO Box","Business Address
Postal
Code","Business Address State","Business Address
Street","Business
Fax","Business Home Page","Business Phone","Business Phone
2","Callback","Car
Phone","Categories","Children","City","Company","Company Main
Phone","Computer Network
Name","Contacts","Country/Region","Created","Customer
ID","Department","E-mail","E-mail 2","E-mail 3","E-mail Display
As","E-mail
Selected","E-mail2 Display As","E-mail3 Display As","Email
Address
Type","Email2 Address Type","Email3 Address Type","FTP
Site","File
As","First
Name","Flag Status","Follow Up Flag","Full
Name","Gender","Government
ID
Number","Hobbies","Home Address","Home Address City","Home
Address
Country","Home Address PO Box","Home Address Postal Code","Home
Address
State","Home Address Street","Home Fax","Home Phone","Home Phone
2","IM
Address","ISDN","In Folder","Initials","Internet Free/Busy
Address","Job
Title","Journal","Language","Last Name","Location","Mailing
Address","Mailing
Address Indicator","Manager's Name","Message Class","Middle
Name","Mileage","Mobile Phone","Modified","NicknameRuss,
thank you for the response before. Sorry to be so lost. I am
guessing
it
is a simple thing I am doing wrong.
Lee
:
You have no need to export anything. Just do your mail merge
from
Outlook.
http://www.slipstick.com/contacts/printlabel.htm
http://www.outlook-tips.net/howto/mailmerge.htm
http://office.microsoft.com/en-us/assistance/HA011186361033.aspx
--
Russ Valentine
[MVP-Outlook]
I have a list of people I want to export from outlook 2003 to
Word
inorder
to
create a mail merge list of labels. I sort my outlook
database
by
category
and hightlight the people I want to export. I then get into
trouble.
No
matter how I do it, I get weird data or erros in word. Can
you
please
go
step by step on what I do to mail merge not just getting to
word
but
all
the
way through to the labels going to print. All the people
have
addresses
in
the address box marked as mailing address in outlook. thanks
you,
Lee
