A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

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.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Word 2007 Mail Merge problems with Excel file providing list



 
 
Thread Tools Display Modes
  #1  
Old June 12th 07, 10:38 PM posted to microsoft.public.word.mailmerge.fields
Matt Sciba
external usenet poster
 
Posts: 1
Default Word 2007 Mail Merge problems with Excel file providing list

I built a custom sized page with text boxes for information.
Basically it's a template for printing addresses on specific parts of
a postcard. Three of the text boxes have common information, but the
fourth will hold the recipient addresses. I start the mail merge in
Word 2007 and choose "letter" as the document form. I follow all of
the steps. My list is linked to the word file because I can view the
addresses and edit the list in Word 2007. After selecting the
recipients, the Address block appears in the text box.

HOWEVER, when I click "Next" which is to preview the mail merge, the
Address block disappears from the text box and prints nothing but
the common information.

PLEASE HELP!

Ads
  #2  
Old June 13th 07, 01:39 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default Word 2007 Mail Merge problems with Excel file providing list

There's a strng case for not using ADDRESSBLOCK (i.e. using individual
fields instead).

However, if you insert ADDRESSLOCK outside a text box, and go to the preview
step, does anything appear? (It does here!) If not, the chances are that
Word has not recognized any of the field names in your Excel file as Address
fields, and you will need to select the ADDRESSBLOCK field, right-click,
Edit Address Block, then Match Fields (or if it makes no difference, use
column names in Excel that Word maps automatically).

When working with fields you may in any case be better off converting your
text boxes to old-style WOrd frames (select the textbox, right-click, Format
Text Box|Text box|Convert to Frame...).

Peter Jamieson

"Matt Sciba" wrote in message
ups.com...
I built a custom sized page with text boxes for information.
Basically it's a template for printing addresses on specific parts of
a postcard. Three of the text boxes have common information, but the
fourth will hold the recipient addresses. I start the mail merge in
Word 2007 and choose "letter" as the document form. I follow all of
the steps. My list is linked to the word file because I can view the
addresses and edit the list in Word 2007. After selecting the
recipients, the Address block appears in the text box.

HOWEVER, when I click "Next" which is to preview the mail merge, the
Address block disappears from the text box and prints nothing but
the common information.

PLEASE HELP!


  #3  
Old June 14th 07, 01:25 AM posted to microsoft.public.word.mailmerge.fields
MS[_4_]
external usenet poster
 
Posts: 3
Default Word 2007 Mail Merge problems with Excel file providing list

On Jun 12, 7:39 pm, "Peter Jamieson"
wrote:
There's a strng case for not using ADDRESSBLOCK (i.e. using individual
fields instead).

However, if you insert ADDRESSLOCK outside a text box, and go to the preview
step, does anything appear? (It does here!) If not, the chances are that
Word has not recognized any of the field names in your Excel file as Address
fields, and you will need to select the ADDRESSBLOCK field, right-click,
Edit Address Block, then Match Fields (or if it makes no difference, use
column names in Excel that Word maps automatically).

When working with fields you may in any case be better off converting your
text boxes to old-style WOrd frames (select the textbox, right-click, Format
Text Box|Text box|Convert to Frame...).

Peter Jamieson

"Matt Sciba" wrote in message

ups.com...

I built a custom sized page with text boxes for information.
Basically it's a template for printing addresses on specific parts of
a postcard. Three of the text boxes have common information, but the
fourth will hold the recipient addresses. I start the mail merge in
Word 2007 and choose "letter" as the document form. I follow all of
the steps. My list is linked to the word file because I can view the
addresses and edit the list in Word 2007. After selecting the
recipients, the Address block appears in the text box.


HOWEVER, when I click "Next" which is to preview the mail merge, the
Address block disappears from the text box and prints nothing but
the common information.


PLEASE HELP!


That didn't work. I had the same result with converting to frames as
I did keeping a text box.

  #4  
Old June 14th 07, 05:57 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default Word 2007 Mail Merge problems with Excel file providing list

Perhaps you could answer my question:

However, if you insert ADDRESSLOCK outside a text box, and go to the
preview
step, does anything appear?


Peter Jamieson
"MS" wrote in message
oups.com...
On Jun 12, 7:39 pm, "Peter Jamieson"
wrote:
There's a strng case for not using ADDRESSBLOCK (i.e. using individual
fields instead).

However, if you insert ADDRESSLOCK outside a text box, and go to the
preview
step, does anything appear? (It does here!) If not, the chances are that
Word has not recognized any of the field names in your Excel file as
Address
fields, and you will need to select the ADDRESSBLOCK field, right-click,
Edit Address Block, then Match Fields (or if it makes no difference, use
column names in Excel that Word maps automatically).

When working with fields you may in any case be better off converting
your
text boxes to old-style WOrd frames (select the textbox, right-click,
Format
Text Box|Text box|Convert to Frame...).

Peter Jamieson

"Matt Sciba" wrote in message

ups.com...

I built a custom sized page with text boxes for information.
Basically it's a template for printing addresses on specific parts of
a postcard. Three of the text boxes have common information, but the
fourth will hold the recipient addresses. I start the mail merge in
Word 2007 and choose "letter" as the document form. I follow all of
the steps. My list is linked to the word file because I can view the
addresses and edit the list in Word 2007. After selecting the
recipients, the Address block appears in the text box.


HOWEVER, when I click "Next" which is to preview the mail merge, the
Address block disappears from the text box and prints nothing but
the common information.


PLEASE HELP!


That didn't work. I had the same result with converting to frames as
I did keeping a text box.


  #5  
Old June 14th 07, 05:52 PM posted to microsoft.public.word.mailmerge.fields
MS[_4_]
external usenet poster
 
Posts: 3
Default Word 2007 Mail Merge problems with Excel file providing list

No. Nothing appeared.

Just this morning I tried to print labels. I used the mailmerge
wizard, or whatever Vista calls it now, and followed the steps. I
used an xls file that I created with Excel 2007. The exact same thing
happened. Everything disappears when I get to the "preview" stage and
it prints a blank sheet. I'm beginning to think it's not a problem
with the text box, but a more fundamental problem with either word
2007 or excel 2007.

  #6  
Old June 14th 07, 05:57 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default Word 2007 Mail Merge problems with Excel file providing list

OK, in that case you probably need to "Match fields", as I said earlier:


and you will need to select the ADDRESSBLOCK field, right-click,
Edit Address Block, then Match Fields (or if it makes no difference, use
column names in Excel that Word maps automatically).


Word does not necessarily recognise the fields you have in your Excel sheet
as address fields - it only looks for certain names (and I don't know what
they are exactly)...

Peter Jamieson

"MS" wrote in message
ps.com...
No. Nothing appeared.

Just this morning I tried to print labels. I used the mailmerge
wizard, or whatever Vista calls it now, and followed the steps. I
used an xls file that I created with Excel 2007. The exact same thing
happened. Everything disappears when I get to the "preview" stage and
it prints a blank sheet. I'm beginning to think it's not a problem
with the text box, but a more fundamental problem with either word
2007 or excel 2007.


  #7  
Old June 14th 07, 06:58 PM posted to microsoft.public.word.mailmerge.fields
MS[_4_]
external usenet poster
 
Posts: 3
Default Word 2007 Mail Merge problems with Excel file providing list

Thank you. The "match fields" worked.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with my links to an excel 2007 file from a word 2007 file sc Microsoft Word Help 1 March 23rd 07 03:03 PM
Mail merge problems in Word 2007 Andrea Jones Mailmerge 0 March 18th 07 09:16 AM
I am having problems doing a mail merge between word & excel vanessa Mailmerge 9 January 24th 07 03:11 PM
Why is Word 2007 providing "File not available" output? kgoodman Microsoft Word Help 5 November 3rd 06 12:35 AM
mail merge word 2007 problems Toskey Microsoft Word Help 3 July 21st 06 03:37 PM


All times are GMT +1. The time now is 05:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.