|
Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word 
Host your Web site with PureHost! 
|
 
Friday, December 05, 2008 – Permalink – Merge Formatting$ lostThe data in Access or Excel has been formatted. You have leading zeros, percents, currency is formatted and so on. Word 200+, however loses the formatting when a mail merge is attempted. Here's a fix. Word has three potential data access methods, the "old fashioned" ODBC or DDE and the newer OLE DB. ODBC and OLE DB can, quickly, extract data from a source application without opening the program. The application does not even have to be installed. The downside is that these methods do not transfer the formatting in the data file. Individual MERGEFIELDs need to be formatted in Word. DDE can be used with Excel and Access. It communicates with the source and carries the formatting into the target document. This is how it worked before Word 2002. To have a choice go to: Tools>Options>General "Confirm Conversions at Open" When you connect to the Data Source, a dialog box will give you the opportunity to choose the type of connection to use.
If you don't see DDE, check Show all. Also see:
Labels: Merge <Doug Klippert@ 7:34 AM
Comments:
Post a Comment
|
