I am trying to merge a form letter with a spreadsheet file using Pages. The form letter was originally created in WordPerfect, then saved as a Word doc so Pages could open it, then saved as a Pages document.
The spreadsheet is one of many I receive each week which I saved as a Numbers document.
The column names in that data document do not match any of the limited Field Names offered by the Mail Merge commands. I tried using that Inspector to add those names. The Field Names (column headings) on the spreadsheet files cannot be changed (they are sent weekly from a company).
Is there any way I can create the Field Names I need in my form letter so it can match my data file and make this merge work?
Thank you for any help.
The spreadsheet is one of many I receive each week which I saved as a Numbers document.
The column names in that data document do not match any of the limited Field Names offered by the Mail Merge commands. I tried using that Inspector to add those names. The Field Names (column headings) on the spreadsheet files cannot be changed (they are sent weekly from a company).
Is there any way I can create the Field Names I need in my form letter so it can match my data file and make this merge work?
Thank you for any help.