#1
|
|||
|
|||
mail merge using data from column A as placeholder.
Hello
i am fairly new to mail merge but have found it straightforward in most of the documents so far. i am using mac 2011. i have an excel sheet where all the data headings (placeholders ? )are in column "A" and the data i wish to merge is in Column "B". i click the "get data" and select " open data source" which opens the excl spreadsheet and places the headings for row 1 as placeholders with the blue asterisk next to them. from this point i can't seem to add or change the placeholders to the ones i want. does anyone know if changing placeholders from rows to columns can be done , if so at that stage do i effect the change. Thanks |
#2
|
||||
|
||||
Hi keys,
Mailmerges require the data to be arranged in columns, with one row per record and the headings at the top of the data in each column, not to one side.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks very much - that will stop me hunting around for an answer that doesn't exists !
much appreciated |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Collation of mail merge data | Nibbles | Excel | 2 | 04-16-2013 07:59 AM |
SlideMaster: Date Placeholder, Footer Placeholder, Slide Number Placeholder? | tinfanide | PowerPoint | 1 | 04-05-2013 10:37 AM |
Mail Merge / DSN / Data Link / MySQL | Bob Young | Mail Merge | 5 | 05-18-2012 03:44 PM |
Mail Merge - If a field is black, take the data from the row below? | mikeprent | Mail Merge | 5 | 01-05-2012 04:52 AM |
Mail Merge Anchoring column layouts | HWSpencer | Mail Merge | 0 | 04-25-2008 06:08 AM |