Mail Merge from an Excel Worksheet problem

N

newbie_D

Hi! When I try to mail merge from an Excel Worksheet of about 100 addresses, Word somehow includes the empty rows in the worksheet where there is not info. there. I ended up have a 6xx pages long merge, not a 100 pages one. Is there a way in Excel to solve this problem

Also, after I enter data for the last column of an entry, how can I make the current cell (the one that being modified or selected, am I using the right term?) jump to the first column of the next row with just hitting the "->" key

Thanks for any idea. :)
 
E

Earl Kiosterud

New,

There's a query capability built into Word's Mail Merge (in 2002, at
least -- don't know about 2000). You could use that to have it include only
records with data in a certain column.

If the rows in the Excel list are totally empty, maybe you want to delete
them, consolidating the list. I think there's code to do that at
www.cpearson.com.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

newbie_D said:
Hi! When I try to mail merge from an Excel Worksheet of about 100
Click to expand...
addresses, Word somehow includes the empty rows in the worksheet where there
is not info. there. I ended up have a 6xx pages long merge, not a 100 pages
one. Is there a way in Excel to solve this problem?
Also, after I enter data for the last column of an entry, how can I make
Click to expand...
the current cell (the one that being modified or selected, am I using the
right term?) jump to the first column of the next row with just hitting the
"->" key?
 
D

David McRitchie

for Part 2 of your question involving navigation within a worksheet,
:
Also, after I enter data for the last column of an entry, how can I make
the current cell (the one that being modified or selected, am I using the
right term?) jump to the first column of the next row
with just hitting the "->" key?
Click to expand...

You would unlock the cells in columns A:F for instance, leaving
G:IV cells locked under Tools --> cells -->Protection. then turn
on sheet protection Tools --> protection --> sheet
But you would have to use the TAB key not the ArrowRt key.

Another way
would be to use an Event macro. Please read the topic
not just the code. Install by RClick on worksheet tab, insert code.
Worksheet_SelectionChange to prevent entry past a column (#ws_sc
Worksheet Events and Workbook Events
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.column < 4 then exit sub
On error resume next 'MUST reenable events...
Application.EnableEvents = False
ActiveCell.Offset(1, 1 - Target.Column).Select
Application.EnableEvents = True
End Sub

Note use of any macro prevents you from using UNDO (ctrl+z),
so you might take another look at worksheet protection and use
of the TAB key.

Sometimes putting two questions in the same posting helps, when
both questions are related and can be quickly answered. Frequently
it works against you delaying your answers. This one worked against you.
And it works against those who simply search newsgroups for answers
because the subject has nothing to do with this part of your question..
In fact the first part of your question doesn't really fit the subject either.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

(see above)
 
U

Unknown

,;Hi! When I try to mail merge from an Excel Worksheet of about 100 addresses, Word somehow includes
the empty rows in the worksheet where there is not info. there. I ended up have a 6xx pages long merge,
not a 100 pages one. Is there a way in Excel to solve this problem?
Click to expand...

Sort the Excel worksheet. This will put all of the blank cells in one
place. Now when you use Mail Merge select the range that includes the
cells with data. You could delete the blank rows at this point unless
there is some reason you need them.
,;
,;Also, after I enter data for the last column of an entry, how can I make the current cell
(the one that being modified or selected, am I using the right term?) jump to the first
column of the next row with just hitting the "->" key?
Click to expand...

What version of Excel? Mine (Excel 2000) does this if you hit the
"Enter" key at the end of a row. Also you could click on <Data> then
on <Form> and use this to enter data.
 
Top