#1
|
|||
|
|||
Mail Merge - how to pad mergefields
We are sending output from a mail merge to a virtual printer which takes the output and puts it into our electronic document imaging system.
While the actual printout and print-to-PDF options work just fine, when sent to the generic/text only printer the table is converted to text, which is expected, but unless each item in a column has the same number of spaces the alignment is messed up between columns. In other software like Excel this is easy to fix; I would change the field to be something like: mergefield + space(80-len(field)): Code:
Currently it looks like this: Column1 Column2 Column3 Item1 desc $1234 $123 Item2 description $2341 $234 Item3 $4567 $456 Should look like this: Column1 Column2 Column3 Item1 desc $1234 $123 Item2 description $2341 $234 Item3 $4567 $456 For example, <<item>> the merge field, when populated, looks like this: ColumnHeading CR/LF Item Line1 CR/LF Item Line2 with more info CR/LF Item Line 3 still different length than Line1 & Line2 CR/LF Making each line the same character width solves the alignment problem. The end user cannot change the source data to match my requirements. I'm fine if this requires some scripting in a macro, whether that macro works on the merge template or the finished merge documents; I'm just not sure how to get "there" from "here". Thank you! |
#2
|
||||
|
||||
I already answered that in this thread: https://www.msofficeforums.com/mail-...ng-spaces.html
Starting another thread with the same question isn't going to change the answer. Thread closed.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge is Deleting objects in my header and footer during the merge | bgranzow | Mail Merge | 9 | 06-05-2015 05:03 AM |
Mail merge how to link mail merge field value to a column heading | dsummers | Mail Merge | 1 | 05-08-2014 02:59 PM |
Export data from C# winForms treeView to MS-Word MergeFields | nisim651 | Mail Merge | 8 | 04-18-2014 04:17 AM |
Mail Merge Duplication of address on merge | RICKY | Mail Merge | 1 | 09-26-2012 03:14 PM |
Saving INDV mail merges During the mail merge | sedain121 | Mail Merge | 2 | 10-04-2011 07:52 PM |