|
|
#1
11-02-2014, 02:28 PM
|
|||
|
|||
Mail Merge Template Not Recognizing Data
Hello, I have a mail merge template that is not pulling data from a spreadsheet. It only pulls the date from F9, and is not recognizing F1 thru F10. I can't figure out what I'm doing wrong. I've attached the template and the excel data I'm trying to pull from (all tabs are set up the same, we only pull from one tab at a time). 
|
|
#2
11-02-2014, 10:37 PM
|
||||
|
||||
|
Why are you using 'F1 thru F10' instead of the field names?
Also, your mailmerge would be far easier to manage if all the records were on the same worksheet. There is no good reason to have a separate sheet for each month. All that does is make consolidation and reporting more difficult. See attached - configured for October. PS: I've deleted your workbook as I doubt your congregation would like their personal & giving details being made available on the web. PPS: Someone needs to spend some time learning to use Word. The plethora of spaces & tabs that have been used for spacing suggest something is trying to use Word like a typewriter.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
| Tags |
| mail merge |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Is data merge and mail merge the same thing? | ikearns | Mail Merge | 1 | 09-12-2014 03:53 AM |
| Creating new documents from a mail merge template | pnjcarter | Mail Merge | 1 | 02-03-2014 06:42 PM |
 Collation of mail merge data
|
Nibbles | Excel | 2 | 04-16-2013 07:59 AM |
| Mail merge into a template | born | Mail Merge | 1 | 09-13-2011 01:42 AM |
| Outlook Template for Word Mail Merge | jhweaver | Mail Merge | 0 | 01-17-2007 06:06 AM |
Windows 8 
Office 2010 32bit
Linear Mode
