Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-16-2011, 07:26 AM
hurstafus hurstafus is offline Specified mail merge (I think) Windows XP Specified mail merge (I think) Office 2003
Novice
Specified mail merge (I think)
 
Join Date: Jun 2011
Posts: 1
hurstafus is on a distinguished road
Default Specified mail merge (I think)

I'm currently looking at creating an automated field entry for reports at my company, extracting the data from an excel file. What I want, is to enter a job number, and it to automatically fill in the title field, author field, and client field from the job number. Essentially it's a lookup from word to excel.



I know that mail merge is a way of linking excel data through to word, but I haven't been able to find a way to have a specific entry to go through as opposed to the entire data field.


If anybody can give me any help on this it would be fantastic.
Reply With Quote
  #2  
Old 06-16-2011, 06:21 PM
macropod's Avatar
macropod macropod is offline Specified mail merge (I think) Windows 7 32bit Specified mail merge (I think) Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,448
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

hi hustafus,

With the mailmerge, you can use record filtering to output only the records you select.

Alternatively, you could combine a SKIPIF filed with a FILLIN field, along the lines of:
{SKIPIF {MERGEREC} <> {FILLIN "Record # to merge" \o}}
or
{SKIPIF{=({MERGEREC}< {FILLIN "First Record #" \d 1 \o})+({MERGEREC}> {FILLIN "Last Record #" \d 999 \o})}= 1}

Note: The field braces (ie '{}') are created via Ctrl-F9 - you can type them or copy them from this post.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Specified mail merge (I think) Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Specified mail merge (I think) mail merge ericlch16 Mail Merge 3 04-30-2011 04:44 AM
Mail Merge nonworduser Mail Merge 0 08-24-2010 02:28 PM
Specified mail merge (I think) help with a mail merge akim281 Mail Merge 2 02-05-2010 02:54 PM
Specified mail merge (I think) mail merge Anthony Outlook 1 09-29-2009 06:09 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft