 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / April 2004Merging from Excel
I am creating a mail merge document from an Excel worksheet source. Everything is fine except that currency amounts appear as 76.5 instead of 76.50. How can I correct this? TIA Ian  Signatureic2@NGntlworld.com Remove NG from my address to send direct. ----- If you do a lookup in the MS Word Help on General Switches, it gives a pretty good explanation of switches and specifically numeric switches that can be added to a merge field to force the decimal places and other formatting. Jackie >-----Original Message----- >I am creating a mail merge document from an Excel worksheet source. [quoted text clipped - 4 lines] > >Ian Thanks Jackie I had done an index search on field and switch and came across the "Format" field switch (\*) which has a subcategory of number formats. Because of this sub-category, I didn't notice the "Numeric Picture" field switch (\#) further down the main list. Easy when you know how :-) Signatureic2@NGntlworld.com Remove NG from my address to send direct. ----- > If you do a lookup in the MS Word Help on General > Switches, it gives a pretty good explanation of switches [quoted text clipped - 12 lines] > > > >Ian See http://www.gmayor.com/formatting_word_fields.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > I am creating a mail merge document from an Excel worksheet source. > Everything is fine except that currency amounts appear as 76.5 [quoted text clipped - 4 lines] > > Ian Thanks Graham. An extremely clear an informative description. I hope you don't mind that I've added your website to my favourites. Signatureic2@NGntlworld.com Remove NG from my address to send direct. ----- > See http://www.gmayor.com/formatting_word_fields.htm > [quoted text clipped - 6 lines] > > > > Ian Any suggestions on how to get the attachments to be included in the sent email. The merge works, however, email when received does not contain attached file? See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Any suggestions on how to get the attachments to be included in the sent > email. The merge works, however, email when received does not contain > attached file? That's what it's there for :) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Thanks Graham. An extremely clear an informative description. I hope > you don't mind that I've added your website to my favourites. [quoted text clipped - 17 lines] >>> >>> Ian
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.