#16
|
|||
|
|||
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 |
#17
|
||||
|
||||
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] |
#18
|
|||
|
|||
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
|
#19
|
||||
|
||||
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] |
#20
|
|||
|
|||
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 |
#21
|
||||
|
||||
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] |
#22
|
|||
|
|||
Is there a way to hide columns in Ms Word tables?.. Appears not!
|
#23
|
||||
|
||||
You could format them as borderless with white content.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
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 |
Need help in automating data from multiple sheets into a single sheet | veedee | Excel | 1 | 06-11-2014 04:01 AM |
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 |
moving data from single to multiple columns? | mzimmers | Excel | 3 | 08-23-2010 08:20 AM |