Mail merge question

[pcor]

Here is what my file looks like:
1 Jan 08 2 Feb 08 12 Mar 08
John Smith 5 7.50
Larry Guy 10 22

I know how to insert a field that would show "5" and "7.50" etc
but is there a way to insert the actual date such as

John Smith

1 jan 08 5
2 feb 08 7.50

Thanks

 

[Graham Mayor]

Here is what my file looks like:
1 Jan 08 2 Feb 08 12 Mar 08
John Smith 5 7.50
Larry Guy 10 22

I know how to insert a field that would show "5" and "7.50" etc
but is there a way to insert the actual date such as

John Smith

1 jan 08 5
2 feb 08 7.50

Thanks

You are going to have to change your data file eg

Name 1 Jan 08 2 Feb 08 12 Mar 08
John Smith 5 7.50
Larry Guy 10 22

Then you would insert

{Mergefield Name}¶
¶
{IF { Mergefield "1 Jan 08" } <> "" "1 jan 08 {Mergefield "1 Jan
08"}"}{IF { Mergefield "2 Feb 08" } <> "" "¶
2 feb 08 {Mergefield "2 Feb 08"}"}{IF { Mergefield "12 Mar 08" } <> ""
"¶
12 Mar 08 {Mergefield "12 Mar 08"}"}

Press the enter key only where you see ¶ as the conditional fields go all on
one line. Each pair of field boundaries {} is inserted with Ctrl+F9


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[pcor]

Many thanks

You are going to have to change your data file eg

Name 1 Jan 08 2 Feb 08 12 Mar 08
John Smith 5 7.50
Larry Guy 10 22

Then you would insert

{Mergefield Name}¶
¶
{IF { Mergefield "1 Jan 08" } <> "" "1 jan 08 {Mergefield "1 Jan
08"}"}{IF { Mergefield "2 Feb 08" } <> "" "¶
2 feb 08 {Mergefield "2 Feb 08"}"}{IF { Mergefield "12 Mar 08" } <> ""
"¶
12 Mar 08 {Mergefield "12 Mar 08"}"}

Press the enter key only where you see ¶ as the conditional fields go all on
one line. Each pair of field boundaries {} is inserted with Ctrl+F9


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Graham Mayor]

You are welcome

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>