If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Source data formatting in mail merges.
I support several hundred users of Office 2003. For the most part, I am very
happy with the product - as are most of my users. However, the Mail Merge feature in Word 2003 has caused some consternation. Several of my users produce fairly detailed "form" letters that include a fairly large number of figures that need to be in currency format. They largely pull these figures from Excel 2003, where the data is formatted as currency. When they attempt to merge this data into the destination merge document in Word 2003, the currency formatting is lost. I have shown these users how to use the picture switch functions, but this is tedious -- especially for large documents with many figures. A simpler, and more "direct" method would certainly be preferable. I would truly love to see this matter addressed in a service release or hotfix, as it is a significant pain (and I am sure that my users are not the only ones complaining). Please address this issue and return convenience to the realm of Mail Merges. Thank you in advance. Sincerely, Steven Fossedal Consultant State of Wisconsin - DMT/BIS/DDES OS2U Project ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...merge.fi elds |
#3
|
|||
|
|||
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm shows how to make
merge as much like its predecessor as possible - see the Excel data section which emphasises Peter's point; however adding standard switches to mergefields can be simplified using autotext or autocorrect to maintain the correct syntax and allows Word to provide control - see also http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Steven Fossedal wrote: I support several hundred users of Office 2003. For the most part, I am very happy with the product - as are most of my users. However, the Mail Merge feature in Word 2003 has caused some consternation. Several of my users produce fairly detailed "form" letters that include a fairly large number of figures that need to be in currency format. They largely pull these figures from Excel 2003, where the data is formatted as currency. When they attempt to merge this data into the destination merge document in Word 2003, the currency formatting is lost. I have shown these users how to use the picture switch functions, but this is tedious -- especially for large documents with many figures. A simpler, and more "direct" method would certainly be preferable. I would truly love to see this matter addressed in a service release or hotfix, as it is a significant pain (and I am sure that my users are not the only ones complaining). Please address this issue and return convenience to the realm of Mail Merges. Thank you in advance. Sincerely, Steven Fossedal Consultant State of Wisconsin - DMT/BIS/DDES OS2U Project ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...merge.fi elds |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
mail merge main document. Word cannot find its data source | Marvin Herrera | Mailmerge | 1 | November 23rd, 2004 12:00 AM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
Word 2003 Mail Merge - Data Source | Sandy | Mailmerge | 1 | August 26th, 2004 01:57 AM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |
Mail Merge uses Outlook instead of Excel data source | Karminak | Mailmerge | 1 | May 21st, 2004 10:20 AM |