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 / April 2004

Tip: Looking for answers? Try searching our database.

Leading blank in mail merge addressblock

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill Rubin - 18 Apr 2004 05:21 GMT
I'm getting a leading blank before the name in my mail merge
output and it's not clear to me where it's coming from. The name
is being pulled in as part of the AddressBlock field.

I'm running Office 2003 if that matters. The blank is not
showing up in step 4 where it shows me the <<AddressBlock>>
format, but it's there is step 5 where it shows me the results
of the merge. What am I doing wrong? I know that it's trying to
pull in a nonexistent company name in the Address block
selection, but even though I unselect it, it keeps getting
selected when I go back to view it, and it's not clear that that
is the problem, anyway. I can manually delete the blanks before
I print if necessary, but it would be nice if I could get it to
generate correctly in the first place.

Thanks..
Bill
Graham Mayor - 18 Apr 2004 09:14 GMT
Frankly I never use the address block so I had to run a test merge using the
wizard to see what you were getting at.
The address block is merely a means of inserting a number of fields. You can
edit the content, by displaying it with ALT+F9, to remove the field that is
causing you grief.

You may find it easier to use an alternative method - see
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and probably
http://www.gmayor.com/mailmerge_from_outlook.htm which will give you more
control over your merges.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP

  Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I'm getting a leading blank before the name in my mail merge
> output and it's not clear to me where it's coming from. The name
[quoted text clipped - 13 lines]
> Thanks..
> Bill
Bill Rubin - 19 Apr 2004 04:20 GMT
Thanks for the reply.. I tried the alt-f9 and got some stuff
showing up but I still do not see where the blank is being
inserted. I'll look at the site you suggested, but worst case
I'll just delete the leading blank before printing -- it's only
50 or 60 addresses that I'm using for invitations. I don't know
why I'm using address block -- it just got created when I set up
the mail merge, and it seemed to do what I wanted, so I stuck
with it.

Bill

> Frankly I never use the address block so I had to run a test merge using the
> wizard to see what you were getting at.
[quoted text clipped - 32 lines]
> > Thanks..
> > Bill

Rate this thread:






 
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.