Mail merge

[Guest]

I've already created the mail merge, it is merged with excel. i was wondering
why there there are cells that do not merge exactly as it is appears in Excel.

Ex.

in Excel:

Darren's classroom attitude shows improvement. He could benefit from
working a little harder on his listening skills. He easily distracted and
therefore, at times, does not listen or follow all of the directions being
given. He could benefit from working a little harder on his listening skills.

but in Word mail merge:

Darren's classroom attitude shows improvement. He could benefit from working
a little harder on his listening skills. He easily distracted and therefore,
at times, does not listen or follow all of the directions being given. He
could benefit from working

some of the text are missing.

please help me with this...
thanks...

 

[macropod]

Hi,

Excel has a notional 255-character limit for a conventional (OBDC)
mailmerge.

Here's a few things you can try. One or more of them might work.
1. Ensure the ranges in Excel are formatted as 'General", not as 'Text';
2. Fill the 1st row in each column with a string of more than 255
characters; and/or
3. Connect to your workbook via DDE.

To use the DDE data transfer method when you're connecting to the data
source (eg Excel) during a mail merge, all you have to do in Word is click
Tools|Options|General,then click "Confirm conversion at Open".

At the step in the mail-merge process where you connect to your data file,
after you locate the file you want to connect to, the "Confirm Data Source"
dialog box opens. Now, click "Application via DDE (*.???)", then "OK". In
the Application dialog box, select the table/range containing the data to
merge, and then click "OK". The mailmerge output will now be formatted the
same as in the source file.

It's probably a good idea to turn off the "Confirm conversion at Open"
option after you finish your mailmerge.

Cheers

 

[Guest]

hi,

I've tried the procedures you've sent but still it doesn't work. However,
other excel file of the same format and longer or composed of numerous
characters (definitely more than 255 char), when I merged it in Word, it
displayed the contents exactly what is expected to display.

There is no problem in Word, even if I use the usual mail merge because I've
several examples.

Hi,

Excel has a notional 255-character limit for a conventional (OBDC)
mailmerge.

Here's a few things you can try. One or more of them might work.
1. Ensure the ranges in Excel are formatted as 'General", not as 'Text';
2. Fill the 1st row in each column with a string of more than 255
characters; and/or
3. Connect to your workbook via DDE.

To use the DDE data transfer method when you're connecting to the data
source (eg Excel) during a mail merge, all you have to do in Word is click
Tools|Options|General,then click "Confirm conversion at Open".

At the step in the mail-merge process where you connect to your data file,
after you locate the file you want to connect to, the "Confirm Data Source"
dialog box opens. Now, click "Application via DDE (*.???)", then "OK". In
the Application dialog box, select the table/range containing the data to
merge, and then click "OK". The mailmerge output will now be formatted the
same as in the source file.

It's probably a good idea to turn off the "Confirm conversion at Open"
option after you finish your mailmerge.

Cheers

--
macropod
[MVP - Microsoft Word]

I've already created the mail merge, it is merged with excel. i was wondering
why there there are cells that do not merge exactly as it is appears in Excel.

Ex.

in Excel:

Darren's classroom attitude shows improvement. He could benefit from
working a little harder on his listening skills. He easily distracted and
therefore, at times, does not listen or follow all of the directions being
given. He could benefit from working a little harder on his listening skills.

but in Word mail merge:

Darren's classroom attitude shows improvement. He could benefit from working
a little harder on his listening skills. He easily distracted and therefore,
at times, does not listen or follow all of the directions being given. He
could benefit from working

some of the text are missing.

please help me with this...
thanks...