Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Caseybay Caseybay is offline
external usenet poster
 
Posts: 6
Default How do I use Excel worksheet #2 as datasource for MailMerge?

I'm using Mail Merge to print contracts. In the past, I've just defined a
range of cells and named it. In step 3 of MailMerge Wizard, when I selected
the recipient list, I browsed to the file, then I get the "Confirm Data
Source" box from which I choose DDE so my dollar formatting won't be messed
up. Next, the "Named or Cell Range" box appears, and the only choice is
"entire spreadsheet". I used to get (last week) the names of my ranges in
there. What am I doing wrong?
I'm using Word 2002 and Excel 2002.
 
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
Referencing Word field contents in a linked Excel worksheet Sniper66 Microsoft Word Help 1 October 3rd 06 10:25 AM
Can't find "Microsoft Excel Worksheet Via Converter" as data sourc Joelle Faulks Mailmerge 7 December 8th 05 09:11 PM
Excel worksheet font changes Jean Microsoft Word Help 1 September 22nd 05 05:46 AM
Display entire Excel worksheet in word doc Regor Microsoft Word Help 1 July 5th 05 07:11 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM


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

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

About Us

"It's about Microsoft Word"