Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-31-2013, 12:57 AM
keys keys is offline mail merge using data from column A as placeholder. Mac OS X mail merge using data from column A as placeholder. Office for Mac 2011
Novice
mail merge using data from column A as placeholder.
 
Join Date: Oct 2013
Posts: 2
keys is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 10-31-2013, 01:43 AM
macropod's Avatar
macropod macropod is offline mail merge using data from column A as placeholder. Windows 7 32bit mail merge using data from column A as placeholder. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 10-31-2013, 01:55 AM
keys keys is offline mail merge using data from column A as placeholder. Mac OS X mail merge using data from column A as placeholder. Office for Mac 2011
Novice
mail merge using data from column A as placeholder.
 
Join Date: Oct 2013
Posts: 2
keys is on a distinguished road
Default

Thanks very much - that will stop me hunting around for an answer that doesn't exists !

much appreciated
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge using data from column A as placeholder. Collation of mail merge data Nibbles Excel 2 04-16-2013 07:59 AM
mail merge using data from column A as placeholder. SlideMaster: Date Placeholder, Footer Placeholder, Slide Number Placeholder? tinfanide PowerPoint 1 04-05-2013 10:37 AM
mail merge using data from column A as placeholder. Mail Merge / DSN / Data Link / MySQL Bob Young Mail Merge 5 05-18-2012 03:44 PM
mail merge using data from column A as placeholder. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft