I have a table in a Word template that contains a mail merge field in the
first cell. The data for the field contains a name, date and amount, each
piece of data separated by a tab (ASCII 9). This was done in the hopes that
the tab would move the cursor to the next cell in the table so the date and
amount would be placed in cells two and three respectively. This doesn't
seem to work. Can anyone suggest how I might accomplish tabbing to the next
cell via data in the mail merge field? Thanks.

Mike

If your data source contains just the one field with the name, date and
amount in that field, there is now way that you can split the mergefield in
the mailmerge main document over three cells.

As you have used tabs to separate the data in the datasource however, it is
a simple matter to convert that into a three column table (using Convert to
Text to Table from the Tables menu and selecting the Tab as the separator).
Then if you add appropriate field names in the the first row cells of each
column, you can merge each individual piece of data into the configuration
that you are after.

--
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

"Mike" wrote in message
...
I have a table in a Word template that contains a mail merge field in the
first cell. The data for the field contains a name, date and amount, each
piece of data separated by a tab (ASCII 9). This was done in the hopes
that
the tab would move the cursor to the next cell in the table so the date
and
amount would be placed in cells two and three respectively. This doesn't
seem to work. Can anyone suggest how I might accomplish tabbing to the
next
cell via data in the mail merge field? Thanks.

Mike

The data source can contain up to ten rows worth of data. It can change each
time. Also, there is no user interaction with the document. A process
initiates the creation of a Word document via a plugin, the data for the
merged fields is inserted and the document is printed in the background.

"Doug Robbins - Word MVP" wrote:

If your data source contains just the one field with the name, date and
amount in that field, there is now way that you can split the mergefield in
the mailmerge main document over three cells.

As you have used tabs to separate the data in the datasource however, it is
a simple matter to convert that into a three column table (using Convert to
Text to Table from the Tables menu and selecting the Tab as the separator).
Then if you add appropriate field names in the the first row cells of each
column, you can merge each individual piece of data into the configuration
that you are after.

--
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

"Mike" wrote in message
...
I have a table in a Word template that contains a mail merge field in the
first cell. The data for the field contains a name, date and amount, each
piece of data separated by a tab (ASCII 9). This was done in the hopes
that
the tab would move the cursor to the next cell in the table so the date
and
amount would be placed in cells two and three respectively. This doesn't
seem to work. Can anyone suggest how I might accomplish tabbing to the
next
cell via data in the mail merge field? Thanks.

Mike

There is nothing that you can do as part of the merge process. You will
have to do it in the data source.

--
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

"Mike" wrote in message
...
The data source can contain up to ten rows worth of data. It can change
each
time. Also, there is no user interaction with the document. A process
initiates the creation of a Word document via a plugin, the data for the
merged fields is inserted and the document is printed in the background.

"Doug Robbins - Word MVP" wrote:

If your data source contains just the one field with the name, date and
amount in that field, there is now way that you can split the mergefield
in
the mailmerge main document over three cells.

As you have used tabs to separate the data in the datasource however, it
is
a simple matter to convert that into a three column table (using Convert
to
Text to Table from the Tables menu and selecting the Tab as the
separator).
Then if you add appropriate field names in the the first row cells of
each
column, you can merge each individual piece of data into the
configuration
that you are after.

--
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

"Mike" wrote in message
...
I have a table in a Word template that contains a mail merge field in
the
first cell. The data for the field contains a name, date and amount,
each
piece of data separated by a tab (ASCII 9). This was done in the hopes
that
the tab would move the cursor to the next cell in the table so the date
and
amount would be placed in cells two and three respectively. This
doesn't
seem to work. Can anyone suggest how I might accomplish tabbing to the
next
cell via data in the mail merge field? Thanks.

Mike