Publipostage word, pied de page et texte conditionné en fonction de la numérotation des pages

Question

Bonjour,

Je rencontre un problème sur un modèle de publipostage Word lors de la réalisation du publipostage.

Mon modèle comporte un certain nombre de pages. 

Pour ce qui est de la gestion des entêtes et pieds de pages, l'option première page différente est cochée.

Ce que je souhaite obtenir :

• sur la première page : les mentions légales de la société. (ça c'est ça fonctionne)
• sur toutes les autres pages (excepté la dernière) : un texte indiquant qu'il faut parapher la page
• sur la dernière page : aucun texte

sur le pied de page de la deuxième page j'ai donc ajouté la condition suivante :

{ IF {PAGE \ MERGEFORMAT} = {SECTIONPAGES \ MERGEFORMAT} "" "Paraphe" }**

j'ai aussi ajouté la numérotation des pages suivante :

{PAGE \ MERGEFORMAT} / {SECTIONPAGES \ MERGEFORMAT}**

lorsque je regarde mon modèle, tout est ok et j'ai bien le résultat attendu.

lorsque je réalise le publipostage sur plusieurs destinataires, la condition ne semble pas fonctionner et le texte est toujours vide.

ce qui m'étonne c'est que par contre, la numérotation des pages elle correspond à ce que j'attends : pour chaque destinataire j'ai bien un numérotation de 1/n à n/n avec une réinitialisation de la numérotation à chaque changement de destinataire.

Quelqu'un aurait-il une idée pour m'aider à avancer sur ce problème ?

D'avance merci pour toute suggestion constructive.

Cordialement, 

M

Answer 1

Hello Doug and thanks for answering my question.

I've been very busy recently so I couldn't test your suggestions until now.

You suggested to modify the test with this one :

{IF {PAGE} < {SECTIONPAGES} "Initials" }

so I changed the = sign with a < sign and modified the displayed text accordingly.

And it didn't work either... I double-checked that the curly brackets are not text but actual Merge Fields curly brackets and they are...

So I'm stuck for now.

Unless I completely miss the point, the tool you provided while being very interesting is most likely not usable for my use-case.

Here I need to give you some more background in order to help understand the context.

1- business context

I'm working for a software company in the real estate field.

In June the law will change to allow owners to vote via real-life mail for the general meeting of co-owners.

I need to generate the required document to be sent to every co-owner in order to give them the opportunity to use the new method.

2- technical context

we are using our software to generate the datasource and then to perform the mailmerge using OLE protocol

the final document is generated with 2 different mailmerge models with their corresponding datasources

• first we mailmerge the resolution list (directory)
• second we insert the resulting document (of the previous mailmerge) into the letter document at the correct position using a bookmark
• third we insert a specific header and footer on the first page and perform the mail merge to generate the IRL mail documents.

when doing so, the document is generated but the footers (from 2nd to the last page of each recipient) are incorrect.

the test on the last page for each recipient does not work and displays the text "please turn the page" while it's the last page ...

It's almost 9:30 pm so I will leave it like this for today.

I will try to generate random datasources if you are interested in seeing the "real" files.

Just let me know.

Kind regards,

M

Answer 2

Hi Doug

It is indeed a good idea to make a french language interface. I will tell you my comments by private email.

There is  a tool, in particulier, that will interest a lot of people, it is the merge with Attachment. 

Could you allow me to relay your tool on my website ? (http://faqword.com).

I just installed your tool, and without really doing a test, if I click a button of the Merge Tools tab, I always obtain an error 13. Can you look what is the reason?

Circé

ps : I think MLeMaudit is not interesting by his question !!

Answer 3

Hi Circé

I believe that the issue will be overcome using my Merge Tools Utilities as it does NOT use mail merge.

I realise that some of the participants in this forum may not understand English, but some might and could be interested in my postings.

On this subject, I have been requested to create a French Language interface for my Merge Tools and would be grateful for your comments on what I have come up with

Answer 4

Hello Doug,

It is very kind of you to provide all this information. But we are on a French-language forum, and if you speak English,  it's not sure that you are understood, or even read.

However your documents are very interesting but I am afraid that they do not answer the question :  most fields do not pass mail merge.

Pour moi, la solution est à faire après la fusion, à savoir une petite macro qui referait le pied de page, une fois la fusion faite.

Cela étant, je ne suis pas certaine que ça intéresse toujours le demandeur... et, comme une fois sur deux, on se décarcasse pour pas grand chose...

Circé

Answer 5

Try using

{IF {PAGE} < {SECTIONPAGES} "Initials" }

You must use CTRL+F9 for each pair of field delimiters and ALT+F9 to toggle off their display.

If that doesn't work, use {IF {PAGE} < {NUMPAGES} "Initials" } and the Merge with Attachments facility on my Merge Tools Add-in that is contained in the MERGE TOOLS ADD-IN.zip file that you can download from the following page of my One Drive:

http://bit.ly/1hduSCB

Extract the files from the archive and read the:

“READ ME – Setting up and using the Merge Tools Add-in.pdf

to see how to install and use the various tools.  Using those tools, it is possible to perform the following types of merge that cannot be done with Mail Merge “out-of-the-box”:

●    Merge to e-mail messages either with or without attachments, with the documents created by the merge being sent as either Word or PDF attachments or as the body of the e-mail message.

●    Merge to individual documents in either Word or PDF format with the filenames being supplied by the data in one of the fields in the data source

●    Many to One type merges, which can be used for creating documents such as invoices where there are multiple records in the data source that have common data in one of the fields

●    Merging to a document that will include a chart that is unique to each record in the data source

●    Merging a document with Content Controls

●    Merging a document that contains Legacy FormFields

●    Duplex Merges

●    Merging to a printer that will collate and staple the output created from each record in the data source.

The requirements for using the system are:

●    The mail merge main document must be of the Letters type, though that does not mean that the output cannot be sent as an e-mail message where relevant.

●    For the Many To One, Merge with Attachments and Merge to Individual Docs utilities, the data source may be either a table or query in an Access database, or in the form of an Excel worksheet and that worksheet must be the first sheet in the Excel workbook. If the data is on some other sheet, you can easily move that sheet so that it is the first sheet in the workbook by clicking on the sheet tab and dragging it to the left.  For the Chart Merge utility, see the Mail Merging with Charts document that is included in the Merge Tools Add-in Zip file for additional requirements for the data source for use with that utility

●    For a data source in the form of an Excel worksheet, the field names must be in the first row of the worksheet and there must be a field name in all of the cells in that row that are within the range of columns that contain the data.

●    For both types of data source, the field names must contain only alphanumeric characters (No @,#,$,%,&,(,), etc) and the field names must not start with a numeric character (0-9). The number of characters in the field names, including spaces, must not be more than 40.

For a demonstration of the use of the facility, see

https://www.youtube.com/watch?v=yj_s3cdfVDY