Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-21-2013, 07:17 PM
willsonfang willsonfang is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jul 2013
Posts: 1
willsonfang is on a distinguished road
Default How would you go about mail merging this set of data

Hi,



I have very little mail merging experience, apart from basic knowledge of it.

Here is my issue,

I have a dataset that contains values for 3 tables, 2 of the 3 tables can have multiple rows, where the other one is always 1 row.

In the same dataset, it also contains normal merge fields (straight mapping).

Attachement is an example of the data. (and yes thats how the data comes in, not very mail merge friendly)

Any help would be appreciated.
Attached Files
File Type: xlsx example.xlsx (10.1 KB, 4 views)
Reply With Quote
  #2  
Old 09-29-2013, 07:16 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,358
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi willsonfang,

Word's mailmerge tools really don't support what you're asking for. You'd need to write a macro to run the whole process.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merging forumlas with Word 2010 aaiden Mail Merge 2 09-30-2013 03:48 PM
Gaps in address mail merging Trixz_D Mail Merge 2 08-05-2012 04:23 AM
Merging three columns of data jdjette Excel 7 03-02-2012 04:48 PM
Mail Merging more than 1 line of data ?? Keith24249 Mail Merge 0 10-16-2009 06:36 AM
Mail merging and pulling varying data from Excel shannag1881 Mail Merge 0 10-05-2009 08:51 AM


All times are GMT -7. The time now is 11:36 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft