Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Larry W. Larry W. is offline
external usenet poster
 
Posts: 1
Default When using mailmerge (WORDfrom ExL), how do you "keep" the ExL for

When using mailmerge (WORD from Excel), how do you "retain" the Excel
formatting?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default When using mailmerge (WORDfrom ExL), how do you "keep" the ExL for

The short answer is that you don't. Word merges the underlying data. See
http://www.gmayor.com/formatting_word_fields.htm for a means of reformatting
the data in Word. However, you *may* find the following will work.

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button Word Options Advanced General Confirm file
format conversion on open). Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.

DDE can however be flaky in use.
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Larry W. wrote:
When using mailmerge (WORD from Excel), how do you "retain" the Excel
formatting?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge with "If" statement producing unexpected results Griffo Mailmerge 2 March 18th 09 08:01 AM
I can't "Open" a downloaded template. Only "Save" and "Cancel" Dave Microsoft Word Help 1 April 4th 08 02:28 PM
What does "char" "char1" "char2" mean in styles in Word? Li Microsoft Word Help 2 September 5th 07 03:22 PM
change order of columns in mailmerge "select recipients" helios Mailmerge 5 August 27th 07 04:23 PM
The "Symbol" under "Insert" disappeared and replaced by "Number" Eling Microsoft Word Help 3 September 13th 06 03:29 PM


All times are GMT +1. The time now is 08:14 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"