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 / November 2007

Tip: Looking for answers? Try searching our database.

Merge to Three Different Letters Depending on the Value in TermYear

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lynda - 01 Nov 2007 19:18 GMT
Hi:

I hope you can help me with this one.  I have a dataset of records (.csv
file) and I want to have certain letters created in mail merge based on the
value in the TermYear field of each of these records.  In other words, if
TermYear is Spring, merge to Spring letter, otherwise merge to Fall letter.
Currently, I have created a letter that just has an IF/THEN?Else statement
that grabs the correct letter and merges to it.  I find this somewhat
awkward though and wondered if there is a better way to accomplish this.
Any suggestions would be greatly appreciated.

Lynda
Peter Jamieson - 02 Nov 2007 10:15 GMT
Longer term it will probably be better to set up one letter (i.e. Mailmerge
main document) for each term, and use the Mailmerge Recipients dialog
(depends on the version of Word) to select the applicable records. Within
that dialog, select the little drop-down at the top of the TermYear field
and select what you need (what does the field actually contain? Does it
contain a year and a term, or just a term?). You may need to select the
Advanced... option there which leads to another dialog box where you can set
up the criteria.

Once you have made the selection, save the mail merge main document, close
it, and re-open it to ensure that your selections have not been lost or
altered (Word does not have a particularly good track record in this area).
Then test the merge (e.g. by merging to a new document).

Peter Jamieson
> Hi:
>
[quoted text clipped - 8 lines]
>
> Lynda
Lynda - 02 Nov 2007 15:13 GMT
Thanks for your help with this.  Your solution does not work in my case
because the csv file has so many fields that the headers disappear in the
recipient list so it is not possible to see the dropdown and hence restrict
the list based on the value in that field.

I cannot load the csv into Excel or Access either because there are too many
fields.

Lynda

> Longer term it will probably be better to set up one letter (i.e.
> Mailmerge main document) for each term, and use the Mailmerge Recipients
[quoted text clipped - 23 lines]
>>
>> Lynda
Peter Jamieson - 02 Nov 2007 15:54 GMT
Which version of Word?

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Thanks for your help with this.  Your solution does not work in my case
> because the csv file has so many fields that the headers disappear in the
[quoted text clipped - 33 lines]
>>>
>>> Lynda
Lynda - 02 Nov 2007 16:53 GMT
I am using Word 2003.

Lynda

> Which version of Word?
>
[quoted text clipped - 36 lines]
>>>>
>>>> Lynda
Peter Jamieson - 02 Nov 2007 18:30 GMT
OK, I'm not sure precisely what you are seeing but here each column in the
Mail Merge Recipients is wide enough to accommodate the title, but if you
need to scroll sideways to find the field you want to filter on, the column
headers do disappear after a few hundred columns. Stuff like that. If that's
what's happening it should be OK to select the first column, click the
dropdown, click (Advanced...), then enter the expression you want in the
Query Options|Filter records dialog.

If you are seeing something else, let us know.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> I am using Word 2003.
>
[quoted text clipped - 40 lines]
>>>>>
>>>>> Lynda
Lynda - 02 Nov 2007 19:37 GMT
Hi Peter:

Thanks!  You solved my problem.  Your solution is exactly the one I was
looking for.

Lynda

> OK, I'm not sure precisely what you are seeing but here each column in the
> Mail Merge Recipients is wide enough to accommodate the title, but if you
[quoted text clipped - 51 lines]
>>>>>>
>>>>>> Lynda
 
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.