Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mail merge
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mail merge
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] "r0zych1x" wrote in message ... 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... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mail merge
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. "macropod" wrote: 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] "r0zych1x" wrote in message ... 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
Mail Merge 255 Character Limit Problem | Excel Discussion (Misc queries) | |||
Difficult for me, probably basic to you | Excel Worksheet Functions | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) |