Paragraph with a field in the middle?

[reel knotty]

Hi Guys I am working on a form letter and would like to have a paragraph on the form but in the middle of the text I would like the members name (which is from a field)

IE
your candidate [member name] has been found worthy to bo initiated into our illustrious order.

I can get it to work by typing the text on either side of the field but it doesn't flow well if the member name is short (there is a large space after the name)

Thanks in advance,
Nate

 

[Fuga]

Try concatenating it in a field in a query:

"your candidate" & [member name] & "has been found worthy to bo initiated into our illustrious order."

Fuga.

 

[reel knotty]

That did it thanks!! I knew it was something simple.

 

[IgorB]

I would correct a little syntax as:

"your candidate" & " " & [member name] & " " & "has been found worthy to bo initiated into our illustrious order."

 

[Fornatian]

Re: Re: Paragraph with a field in the middle?

I would correct a little syntax as:

"your candidate" & " " & [member name] & " " & "has been found worthy to bo initiated into our illustrious order."

I would correct a little syntax as:

"your candidate " & [member name] & " has been found worthy to be initiated into our illustrious order."

If you want to be pedantic.

 

[reel knotty]

Yeah guys I found the space issue after i viewed it. Thanks for the help.


Lets go fishin!