Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Kathy Kathy is offline
external usenet poster
 
Posts: 146
Default mail merge with excel data source

Data in excel, workbook with multiple sheets. Monthly I do a merge (letter
or labels) with current sheet entering data on. In word when connecting to
data file, use an existing list, browse, choose data, select which sheet to
work with in workbook, window mail merge receipients comes up, I then check
the people to merge.

Other times, after selecting worksheet in workbook, I get a window "select a
table". when I highlight workbook: c:/documents.... the cancel key in the
window will highlight and does nothing. I have copied data to a sheet that I
can merge with and that works generally, but need to see what is causing this
glitch i.e. permission, options, etc.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default mail merge with excel data source

Responded in the mailmerge.fields group.

Peter Jamieson
"Kathy" wrote in message
...
Data in excel, workbook with multiple sheets. Monthly I do a merge
(letter
or labels) with current sheet entering data on. In word when connecting
to
data file, use an existing list, browse, choose data, select which sheet
to
work with in workbook, window mail merge receipients comes up, I then
check
the people to merge.

Other times, after selecting worksheet in workbook, I get a window "select
a
table". when I highlight workbook: c:/documents.... the cancel key in
the
window will highlight and does nothing. I have copied data to a sheet
that I
can merge with and that works generally, but need to see what is causing
this
glitch i.e. permission, options, etc.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge from excel data source Kathy Mailmerge 3 July 14th 07 10:56 PM
Mail Merge from Excel data source Santa-D Microsoft Word Help 8 January 23rd 07 05:15 AM
Excel Data Source Changes not reflected in the Mail Merge Dave Baxandall Mailmerge 1 July 12th 06 10:45 PM
Mail Merge using an Excel spreadsheet as a data source SharronTucker Microsoft Word Help 2 June 24th 05 06:11 PM
mail merge using excel file as data source Laurina Mailmerge 1 January 31st 05 03:10 PM


All times are GMT +1. The time now is 03:21 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"