Microsoft Office Forums How would you go about mail merging this set of data

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-21-2013, 07:17 PM
willsonfang willsonfang is offline How would you go about mail merging this set of data Windows 7 64bit How would you go about mail merging this set of data Office 2010 64bit
Novice
How would you go about mail merging this set of data
 
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 How would you go about mail merging this set of data Windows 7 32bit How would you go about mail merging this set of data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,524
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
How would you go about mail merging this set of data 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:08 AM.


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