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

Tip: Looking for answers? Try searching our database.

Merging data from Excel...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike - 25 Feb 2004 19:11 GMT
Ok, I'm going crazy:

I have an Excel ss with multiple tabs.  One tab - the DATA tab -
contains formulas that pull data from the other tabs (I use VLOOKUP
function a lot).  This way, my users can add data to the other tabs
and not mess up the actual tab used for the mail merge - the Data tab.

This (is) was working great.  I created the Word doc and merged all
the fields.  A day or so ago someone manually typed in information
overwriting two of the mail merge fields, and then saved the doc.  I
have re-mapped the fields to the Excel file, however the fields do no
pull data.  Here's the weird thing - those two fields are part of a
four field named reference - a named range on one of the other tabs in
the main Excel ss.  In the mail merge doc, two of the four mail merge
fields will pull data from the Data tab, but the other two (the 2 that
were overwritten) will not.  When I click on the Mail Merge Recipients
toolbar button it brings up the Data tab in Excel - all the fields map
EXCEPT the two that were overwritten.

I have remapped the fields in Word.  I've reconfigured the data
source.  I've reconfigured the named range on the excel tab.  Nothing
is working.  I could see if the data wasn't showing up in the formula
on the Data tab, but it is so how can the data show up in the formula
on the "Data" tab and not in the Word mail merge?!?!

Please help!  Version is Office 2002 on Windows XP Pro.

Thanks much!
Michael
Peter Jamieson - 26 Feb 2004 05:42 GMT
If you are using mapped fields, are you using the \m switch in the
appropriate MERGEFIELD fields to specify that the field name is mapped?

(I'm quite interested to know why you are mapping fields at all)

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Ok, I'm going crazy:
>
[quoted text clipped - 25 lines]
> Thanks much!
> Michael
Mike - 27 Feb 2004 12:34 GMT
Actually, I'm not mapping the fields.  I was incorrect in that statement.

> If you are using mapped fields, are you using the \m switch in the
> appropriate MERGEFIELD fields to specify that the field name is mapped?
[quoted text clipped - 34 lines]
> > Thanks much!
> > Michael
Peter Jamieson - 27 Feb 2004 13:38 GMT
OK, the "mapping" thing really threw me.

I can't currently replicate this (I only have a really simple example here
though) but maybe you could spell out a few things - or even send the .doc
and .xls to my despammed address.

Are you using the default connection method (OLEDB)? If you are connecting
via the converter, I think you may experience missing data problems

I
> > > have re-mapped the fields to the Excel file, however the fields do no
> > > pull data.

By "re-mapped" can we assume you re-inserted them from the drop-down list in
Word?

> > > Here's the weird thing - those two fields are part of a
> > > four field named reference - a named range on one of the other tabs in
> > > the main Excel ss.

By a "four field named reference" do you mean a 4-column area with a range
name, or are you doing something more complicated than that?

> > > were overwritten) will not.  When I click on the Mail Merge Recipients
> > > toolbar button it brings up the Data tab in Excel - all the fields map
> > > EXCEPT the two that were overwritten.

Do you mean that the two overwritten fields are simply absent from the
recipient list, that the column headings are there but the data is missing,
or something else?

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Actually, I'm not mapping the fields.  I was incorrect in that statement.
>
[quoted text clipped - 36 lines]
> > > Thanks much!
> > > Michael
 
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.