[mso] Re: Fw: Re: Printing labels
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sun, 15 Sep 2002 15:37:00 -0400
Does your Excel spreadsheet have column headers that say things like
Last Name, First Name, etc? If so, make sure this row is formatted
differently from the rest....just make it bold or something...I have
seen mail merges done where the headings are in the same format as
everything else and word can't recognize them as headings
Does your Excel spreadsheet have blank lines in it? If so, remove them.
A mail merge stops when it sees blank lines and won't include any data
after the blank line. If you want your spreadsheet to have space
between the entries, just make your rows taller....never use blank lines
or columns in Excel..they cause lots of problems.
If you want, you can send me the Excel spreadsheet and I will try to do
a merge with it here...unless the info is confidential, obviously....but
I may be able to fix this faster for you if I have the spreadsheet here.
If you send it to me, let me know which version of Office you are using
so I don't screw up any formats by opening it in the wrong version here.
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Jan Robey
Sent: Sunday, September 15, 2002 3:07 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Fw: Re: Printing labels
No where along the way does it give me that choice. But I created a new
spread sheet with the same info & renamed it. Tried the same routine &
this time I got labels, but they are all the same, which happens to be
the first name on the list. I can change each one by coping & pasting
but this is very tedious.
Any more suggestions would be appreciated.
Jan
*************************************************************
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?Subject=unsubscribe
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:
