LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
abbaszaidi
 
Posts: n/a
Default Mail merge works with Forms but not with Labels


::
Hi,

I am importing data for a Form and Label merge from Excel into Word. My
columns in excel are as follows :

Cust ID#/ Company/ JobTitle / BusinessStreet / BusinessCity /
BusinessState BusinessPostalCode


Some of these records have blank lines.

When i do an import into Word as FORM it works okay and suppresses
blank lines.

However, when i import into labels even though word SAYS it will
suppress blank lines it does not.

There has to be some way other than pressing delete 2000 times on blank
lines!

Any ideas?::


--
abbaszaidi
------------------------------------------------------------------------
abbaszaidi's Profile: http://www.excelforum.com/member.php...o&userid=12946
View this thread: http://www.excelforum.com/showthread...hreadid=382955

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailing labels, mail merge motodom Excel Discussion (Misc queries) 1 January 17th 05 06:29 PM
When printing labels by using Excel data in a Word mail merge, ho. Jerry Excel Discussion (Misc queries) 2 January 2nd 05 01:27 PM
Extract Data for Mail Merge Rashid Khan Excel Discussion (Misc queries) 7 December 24th 04 05:47 PM
Can you print labels using Excel 2002 in a Word 2002 mail merge? Individual_ Excel Discussion (Misc queries) 3 December 17th 04 08:39 PM
How do I print a partial page of labels using Mail merge? Daffy820 Excel Discussion (Misc queries) 1 December 13th 04 08:51 PM


All times are GMT +1. The time now is 01:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"