Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tinaponders
 
Posts: n/a
Default Mail merge with specific work sheet

I have an excel file with various worksheets, how can i create a mail merge
letter selecting just one of the work sheets. I am working off Microsoft
2000.
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Mail merge with specific work sheet

Hi Tina,
You can only use one worksheet. That worksheet should be the
first tab in the workbook. Directions for printing labels in
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

A letter would be pretty much the same but you might prefer one of the
other pages perhaps the one by Cindy Meister (see links at)
http://www.mvps.org/dmcritchie/excel/excel.htm#more

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Tinaponders" wrote in message ...
I have an excel file with various worksheets, how can i create a mail merge
letter selecting just one of the work sheets. I am working off Microsoft
2000.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying a work sheet cell reference as relative not absolute? Velson Excel Discussion (Misc queries) 4 January 7th 06 01:46 PM
Sum of 3 nos. into 1 cell in another sheet relevant to specific da Ellie Excel Discussion (Misc queries) 0 September 19th 05 04:57 PM
How to filter on a date field during mail merge SWADoug Excel Worksheet Functions 0 June 21st 05 06:31 PM
help removing duplicates for mail merge jeff quigley Excel Discussion (Misc queries) 0 June 13th 05 08:05 PM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM


All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"