Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-12-2014, 05:26 AM
SteveVai SteveVai is offline Merge fields in Word and source data from Excel Windows 7 64bit Merge fields in Word and source data from Excel Office 2010 64bit
Novice
Merge fields in Word and source data from Excel
 
Join Date: Mar 2014
Posts: 2
SteveVai is on a distinguished road
Default Merge fields in Word and source data from Excel

Hi everyone,

I was wondering if someone knew how to do the following-



I have a serious of data from an excel worksheet, in columns A & B as follows-: Note: Column A is static data, Column B is the variable...

DATE 12 March 2014
SALUTATIONM Mr


I want to be able to insert merge fields from column A, throughout certain places of a word document? For instance every time the merge field says DATE in the word document, the 12 March 2014 would appear. Anywhere SALUTATIONM merge fieldappears, Mr would appear.

I have something like over 100 different column codes, however I've kept this simple for this specific example anyway.

Any help or guidance would be greatly appreciated.
Reply With Quote
  #2  
Old 03-12-2014, 06:11 AM
macropod's Avatar
macropod macropod is offline Merge fields in Word and source data from Excel Windows 7 32bit Merge fields in Word and source data from Excel 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

You can put your mergefields wherever you like in the mailmerge main document, multiple times, if you wish. Instead of having DATE and SALUTAIONM in the document, though, you'd insert mergefields at those locations, referencing your column headings in Excel.

FWIW, you post suggests you need to spend a bit more time learning how mailmerge works. See:
http://office.microsoft.com/en-us/wo...001034920.aspx
http://support.microsoft.com/kb/294683
http://office.microsoft.com/en-us/wo...101857701.aspx
http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-12-2014, 07:57 AM
Charles Kenyon Charles Kenyon is offline Merge fields in Word and source data from Excel Windows 7 64bit Merge fields in Word and source data from Excel Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

You need Date and Salutation to be column headings in the first row in your Excel spreadsheet. The next row would have March 12, 2014 and Mr. Following rows would have the data for other records.

First row = header - corresponds to your merge field names
Following rows = data

See Mail Merge
Reply With Quote
  #4  
Old 03-13-2014, 05:25 AM
SteveVai SteveVai is offline Merge fields in Word and source data from Excel Windows 7 64bit Merge fields in Word and source data from Excel Office 2010 64bit
Novice
Merge fields in Word and source data from Excel
 
Join Date: Mar 2014
Posts: 2
SteveVai is on a distinguished road
Default

Thanks guys for your help. I managed to get it working with your guidance..

Thanks again
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge fields in Word and source data from Excel Enable Mail Merge Data Source always in same folder alleycat1998 Mail Merge 1 04-10-2013 03:02 AM
Merge fields in Word and source data from Excel How to dynamically link imbedded Excel chart with source data from Word TBoz Excel 1 07-06-2012 05:53 PM
Merge fields in Word and source data from Excel How can I revise Excel data source in merge? navysalad Mail Merge 6 01-07-2012 06:50 PM
Mail Merge data source on network drive Brandi Mail Merge 0 06-13-2010 11:26 AM
How do I set up the fields in mail merge word 07 from my data base mbcrabber Mail Merge 4 06-06-2010 01:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:11 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