Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 09-23-2014, 10:08 AM
Nisio07 Nisio07 is offline Single data piece from header? Windows 7 64bit Single data piece from header? Office 2007
Novice
Single data piece from header?
 
Join Date: Sep 2014
Posts: 21
Nisio07 is on a distinguished road
Default

Sometimes it is easier to see the files rather than write pages of instructions.

My aim two problems are:

the hit/miss nature of the INCLUDETEXT field/command - Have I got something wrong (PS I am only interested in cell 1, I will populate the other cells when all is in order

the prompt for mail merge data source which occurs every time the FLASH file is open.

A final BTW is that bookmarked data on the RPT file will be replaced/deleted every time. am I right in assuming that as the data is deleted so too will the bookmark? If so, how best to overcome this - a little marco to assign each data field to a bookmark which can then be referenced in the FLASH file?



With thanks ..

Regards
Attached Files
File Type: docx 1-RADM-Flash-cURRENT.docx (20.4 KB, 10 views)
File Type: doc 1-RADM-Rpt.doc (58.5 KB, 10 views)
Reply With Quote
  #17  
Old 09-23-2014, 02:59 PM
macropod's Avatar
macropod macropod is offline Single data piece from header? Windows 7 64bit Single data piece from header? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

OK, I see what's happening now - the FILENAME field is being converted to its results before the INCLUDETEXT field gets to evaluate the field expression. I guess that rules out using the INCLUDETEXT field in this situation. Cross-referenced bookmarks in the data source don't seem to work, either. In that case, you'll have to either:
• add the required columns to your data file so the mailmerge can reference them; or
• forego the conventional mailmerge process and drive it all with a macro instead.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #18  
Old 09-23-2014, 11:10 PM
Nisio07 Nisio07 is offline Single data piece from header? Windows 7 64bit Single data piece from header? Office 2007
Novice
Single data piece from header?
 
Join Date: Sep 2014
Posts: 21
Nisio07 is on a distinguished road
Default

The data needed from the INCLUDETEXT commands required are NOT required in the original RPT, which is being circulated to customers? can they be included but hidden as a column in the table? I would like to keep this as simple as possible and thus avoid Macros
Reply With Quote
  #19  
Old 09-23-2014, 11:28 PM
macropod's Avatar
macropod macropod is offline Single data piece from header? Windows 7 64bit Single data piece from header? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If the data from the INCLUDETEXT fields aren't required, why do they appear in the 1-RADM-Rpt.doc and why did you say "I need to use some of the data from the header and footer on each label"?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #20  
Old 09-23-2014, 11:53 PM
Nisio07 Nisio07 is offline Single data piece from header? Windows 7 64bit Single data piece from header? Office 2007
Novice
Single data piece from header?
 
Join Date: Sep 2014
Posts: 21
Nisio07 is on a distinguished road
Default

The date is entered once on the RPT (i.e the header), then a table of "items" is listed on the RPT. This RPT is then used to generated individual labels - which as well as using row data from the table also used the sole date entry from the header as well as other singular data (such as incident number and project name). Also, I will not be running this file/rpt myself (I am just attempting to automate a very slow, manual, duplicated data entry process) so would like to keep as low maintenance as possible, (in the event of anything going wrong) and would thus like to avoid Macros..

Apologies -- the data is not needed IN COLUMNS FORMAT .. I.E. entered multiple times.. it is static and is just entered once, in header not per row
Reply With Quote
  #21  
Old 09-24-2014, 12:41 AM
macropod's Avatar
macropod macropod is offline Single data piece from header? Windows 7 64bit Single data piece from header? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Basically, you have three choices:
1. Duplicate the 'header' data on every row of the merge table, as I've already said; or
2, if you want to use an INCLUDETEXT field, revert to an ordinary INCLUDETEXT field (i.e. without the embedded FILENAME field) but you'll need to update & unlink the fields in the output document (e.g. via Ctrl-A, F9, Ctrl-Shift-F9) after finishing the merge.
3. forget about mailmerge and drive the process via a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #22  
Old 09-24-2014, 12:48 AM
Nisio07 Nisio07 is offline Single data piece from header? Windows 7 64bit Single data piece from header? Office 2007
Novice
Single data piece from header?
 
Join Date: Sep 2014
Posts: 21
Nisio07 is on a distinguished road
Default

Is there a way to hide columns in Ms Word tables?.. Appears not!
Reply With Quote
  #23  
Old 09-24-2014, 01:21 AM
macropod's Avatar
macropod macropod is offline Single data piece from header? Windows 7 64bit Single data piece from header? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could format them as borderless with white content.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help in automating data from multiple sheets into a single sheet veedee Excel Programming 8 06-12-2014 10:04 PM
Single data piece from header? Need help in automating data from multiple sheets into a single sheet veedee Excel 1 06-11-2014 04:01 AM
Single data piece from header? Merge data repeatedly in a single document MathTeacherMelanie Mail Merge 10 11-13-2012 07:05 PM
Remove header/footers from a single page qwerty2k12 Word 1 03-01-2012 08:14 PM
Single data piece from header? moving data from single to multiple columns? mzimmers Excel 3 08-23-2010 08:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:09 PM.


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