A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

anchor line while merging



 
 
Thread Tools Display Modes
  #1  
Old April 10th, 2009, 11:22 PM posted to microsoft.public.word.mailmerge.fields
BotR
external usenet poster
 
Posts: 9
Default anchor line while merging

I’m doing a mail merge with a form letter. I have 5 fields in the data for
the address. Not all the fields are used all the time. Sometimes the
address is only 3 lines long, sometimes 5. After I merge the data to the
form letter, the first paragraph after the merge fields starts on a different
line depending on long the address was.

My question, is there a way to anchor the start of a line so it doesn’t
move. Just like anchoring a picture or text box. And no, I don’t want to
use a text box for my letter. Or do I have to use “IF” field = blank, “Enter”



Thanks

  #2  
Old April 10th, 2009, 11:28 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP on news.microsoft.com
external usenet poster
 
Posts: 409
Default anchor line while merging

You could put the address mergefields inside a one cell table for which you
fix the dimensions of the cell.

--
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, originally posted via msnews.microsoft.com

"BotR" wrote in message
...
I'm doing a mail merge with a form letter. I have 5 fields in the data
for
the address. Not all the fields are used all the time. Sometimes the
address is only 3 lines long, sometimes 5. After I merge the data to the
form letter, the first paragraph after the merge fields starts on a
different
line depending on long the address was.

My question, is there a way to anchor the start of a line so it doesn't
move. Just like anchoring a picture or text box. And no, I don't want to
use a text box for my letter. Or do I have to use "IF" field = blank,
"Enter"



Thanks



  #3  
Old April 11th, 2009, 11:58 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default anchor line while merging

Other than putting the address fields in a fixed-depth object such as a
table fellas per Doug's suggestion, a text box (not clear whether it is
all text boxes you want to avoid, or whether you want to avoid putting
the letter body in a text box), or a frame, I suspect you are left with
using an { ADVANCE } field to start your body text at an absolute
position. But I'd avoid { ADVANCE } unless there's no alternative.

Peter Jamieson

BotR wrote:
I’m doing a mail merge with a form letter. I have 5 fields in the
data for
the address. Not all the fields are used all the time. Sometimes the

address is only 3 lines long, sometimes 5. After I merge the data to
the
form letter, the first paragraph after the merge fields starts on a
different
line depending on long the address was.

My question, is there a way to anchor the start of a line so it
doesn’t
move. Just like anchoring a picture or text box. And no, I don’t
want to
use a text box for my letter. Or do I have to use “IF” field = blank,
“Enter”



Thanks

  #4  
Old April 11th, 2009, 07:52 PM posted to microsoft.public.word.mailmerge.fields
BotR
external usenet poster
 
Posts: 9
Default anchor line while merging

Thanks Peter. {ADVACE} worked after I played with it. This is how it
worked....

{Addy1}
{Addy2}
{Addy3}
{Addy4}
{Addy5}


{ADVANCE \y 216}Dear {MERGEFIELD "FirstName},

Once I figured out that 1 inch = 70pts and they wanted it in points, it
worked out great.

Thanks for the tip. It was driving me nuts.

BotR


"Peter Jamieson" wrote:

Other than putting the address fields in a fixed-depth object such as a
table fellas per Doug's suggestion, a text box (not clear whether it is
all text boxes you want to avoid, or whether you want to avoid putting
the letter body in a text box), or a frame, I suspect you are left with
using an { ADVANCE } field to start your body text at an absolute
position. But I'd avoid { ADVANCE } unless there's no alternative.

Peter Jamieson

BotR wrote:
I’m doing a mail merge with a form letter. I have 5 fields in the
data for
the address. Not all the fields are used all the time. Sometimes the

address is only 3 lines long, sometimes 5. After I merge the data to
the
form letter, the first paragraph after the merge fields starts on a
different
line depending on long the address was.

My question, is there a way to anchor the start of a line so it
doesn’t
move. Just like anchoring a picture or text box. And no, I don’t
want to
use a text box for my letter. Or do I have to use “IF” field = blank,
“Enter”



Thanks


  #5  
Old April 11th, 2009, 08:12 PM posted to microsoft.public.word.mailmerge.fields
garfield-n-odie [MVP]
external usenet poster
 
Posts: 4,427
Default anchor line while merging

1 inch = 72 points.

BotR wrote:

Thanks Peter. {ADVACE} worked after I played with it. This is how it
worked....

{Addy1}
{Addy2}
{Addy3}
{Addy4}
{Addy5}


{ADVANCE \y 216}Dear {MERGEFIELD "FirstName},

Once I figured out that 1 inch = 70pts and they wanted it in points, it
worked out great.

Thanks for the tip. It was driving me nuts.

BotR


"Peter Jamieson" wrote:


Other than putting the address fields in a fixed-depth object such as a
table fellas per Doug's suggestion, a text box (not clear whether it is
all text boxes you want to avoid, or whether you want to avoid putting
the letter body in a text box), or a frame, I suspect you are left with
using an { ADVANCE } field to start your body text at an absolute
position. But I'd avoid { ADVANCE } unless there's no alternative.

Peter Jamieson

BotR wrote:

I’m doing a mail merge with a form letter. I have 5 fields in the
data for
the address. Not all the fields are used all the time. Sometimes the

address is only 3 lines long, sometimes 5. After I merge the data to
the
form letter, the first paragraph after the merge fields starts on a
different
line depending on long the address was.

My question, is there a way to anchor the start of a line so it
doesn’t
move. Just like anchoring a picture or text box. And no, I don’t
want to
use a text box for my letter. Or do I have to use “IF” field = blank,
“Enter”



Thanks



  #6  
Old April 11th, 2009, 10:34 PM posted to microsoft.public.word.mailmerge.fields
BotR
external usenet poster
 
Posts: 9
Default anchor line while merging

Correct, my bad

"garfield-n-odie [MVP]" wrote:

1 inch = 72 points.

BotR wrote:

Thanks Peter. {ADVACE} worked after I played with it. This is how it
worked....

{Addy1}
{Addy2}
{Addy3}
{Addy4}
{Addy5}


{ADVANCE \y 216}Dear {MERGEFIELD "FirstName},

Once I figured out that 1 inch = 70pts and they wanted it in points, it
worked out great.

Thanks for the tip. It was driving me nuts.

BotR


"Peter Jamieson" wrote:


Other than putting the address fields in a fixed-depth object such as a
table fellas per Doug's suggestion, a text box (not clear whether it is
all text boxes you want to avoid, or whether you want to avoid putting
the letter body in a text box), or a frame, I suspect you are left with
using an { ADVANCE } field to start your body text at an absolute
position. But I'd avoid { ADVANCE } unless there's no alternative.

Peter Jamieson

BotR wrote:

I’m doing a mail merge with a form letter. I have 5 fields in the
data for
the address. Not all the fields are used all the time. Sometimes the

address is only 3 lines long, sometimes 5. After I merge the data to
the
form letter, the first paragraph after the merge fields starts on a
different
line depending on long the address was.

My question, is there a way to anchor the start of a line so it
doesn’t
move. Just like anchoring a picture or text box. And no, I don’t
want to
use a text box for my letter. Or do I have to use “IF” field = blank,
“Enter”



Thanks



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.