Reply
 
Thread Tools Display Modes
  #1   Report Post  
jonh
 
Posts: n/a
Default Line Break in a simple label mail merge

I am trying to use Word & Excel to merge for a mass mailing (labels).

Using the address block works fine, but I had to insert a database field for
a 3rd address line from the db. This also work ok, except that address line
3 ends up on the same line as the city & postal code etc.

Is there a way to force a line break to separate address 3 if it prints?

Thanks
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

Instead of using the addressblock, insert the individual mergefields in the
configuration that you want them.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"jonh" wrote in message
...
I am trying to use Word & Excel to merge for a mass mailing (labels).

Using the address block works fine, but I had to insert a database field
for
a 3rd address line from the db. This also work ok, except that address
line
3 ends up on the same line as the city & postal code etc.

Is there a way to force a line break to separate address 3 if it prints?

Thanks



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to merge data into a table and keep it's contents in line Profjekyll Mailmerge 0 September 15th 05 01:49 PM
Address Line Format for Mail Merge Misha Mailmerge 1 August 2nd 05 04:52 AM
custom label page size in mail merge (on a mac) Beee Mailmerge 1 January 7th 05 05:56 AM
Mail Merge Label layout. Brian Ellis Mailmerge 3 December 9th 04 05:32 PM
mail merge only prints one label per page Golpher Mailmerge 1 December 9th 04 12:47 AM


All times are GMT +1. The time now is 07:49 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"