Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Andy Andy is offline
external usenet poster
 
Posts: 90
Default Mail Merging a Selection from within an Excel Sheet

Wondering if you can help, I'm kind of learning this as I go along so
apologies if this is a really dumb question.

I need to setup a mail merge that will use a specific selection from an
Excel Sheet. For example everything under the column "University" that
contains "LBS" needs to be merged. I can do this manually by either selecting
the right records when I mail merge, or create a new spreadsheet containing
only the records I need. But I want to create a wonderful Macro that does it
all for me. Is there a way to create a a macro that will look at a Tab on a
Spreadsheet then look at a specific column and merge only the records with a
certain entry. I hope that makes sense...

Thanks all

 
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
Can't display excel sheet within Word (EMBED Excel.Sheet.8) HR Duvall Microsoft Word Help 3 May 14th 23 02:49 AM
How do i mail merge in word from an excel sheet? Connie Mailmerge 1 June 16th 06 04:32 AM
How to specify Excel sheet name as mail merge source Peter Jamieson Mailmerge 2 May 5th 05 08:49 AM
Missing information when merging excel sheet in Catalogue document fredgo Mailmerge 1 March 24th 05 11:40 AM
Merging excel 2003 spread sheet to word 2000 document Pat moore via OfficeKB.com New Users 1 February 18th 05 02:30 PM


All times are GMT +1. The time now is 07:39 AM.

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"