Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2004

Tip: Looking for answers? Try searching our database.

How do you keep mail merge from indenting one space on the first .

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
competitor - 28 Oct 2004 16:25 GMT
Whenever I perform a mail merge, the first line of every record is indented
one space.  How do I prevent this from happening?  Also, if I use an excel
file for my recipient file and a field contains a numeric value with commas,
the comma never appears in the mail merge file.  What do I need to do in
order to have the commas displayed?
Peter Jamieson - 28 Oct 2004 20:44 GMT
A few obvious things to consider:
Are there any leading spaces in your data records?
Is the "space" composed of space characters, or perhaps indents to do with
a paragraph layout or style?
What characters/field codes are there in your mail merge main document?

As for the commas in numeric fields, there are two approaches you can take:
Use DDE to connect to your Excel data, and you will /probably/ see the
commas (in Word 2002 and later, check Word Tools|Options|General|"Confirm
conversion at open", then go through the data source selection process again
and select the DDE option when prompted.
Use "Numeric field switches in your mergefields, e.g. instead of

{ MERGEFIELD mynumber }

try

{ MERGEFIELD mynumber \#$,0.00 }

These switches are documented in Word Help.

Peter Jamieson

> Whenever I perform a mail merge, the first line of every record is
> indented
[quoted text clipped - 3 lines]
> the comma never appears in the mail merge file.  What do I need to do in
> order to have the commas displayed?
 
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.