Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2012, 08:45 AM
nadja nadja is offline mail merge with table Windows XP mail merge with table Office 2010 32bit
Novice
mail merge with table
 
Join Date: Feb 2012
Posts: 3
nadja is on a distinguished road
Default mail merge with table

Hi,
I've never done this kind of thing before and couldn't find any answers on the forum, so I'm hoping someone can help me write my letters

I have attached a picture of the columns I have in my excel spreadsheet.

Now I would like to create 1 letter per customer (column B) and also include a table at the end of my letter consisting of the last 6 columns.

I hope this is clear, but please ask if it's not or you need any further info.



Thanks in advance to all you skilled people out there!
Nadja
Attached Images
File Type: jpg excel.JPG (82.7 KB, 28 views)
Reply With Quote
  #2  
Old 02-23-2012, 07:20 PM
macropod's Avatar
macropod macropod is offline mail merge with table Windows 7 64bit mail merge with table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,225
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Hi nadja,

There has been a number of posts in this forum (and in numerous others) on this topic.

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial, in the 'Sticky' thread at the top of this forum:
Microsoft Word Catalogue/Directory Mailmerge Tutorial
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

For a recent, worked example, see the attachment to post #13 at: https://www.msofficeforums.com/mail-...nt-dollar.html

Alternatively, you may want to try the Many to One utility on the MergeTools Add-in that you can download from the following page of Doug Robbins' Windows Live SkyDrive: Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-05-2012, 07:05 AM
nadja nadja is offline mail merge with table Windows XP mail merge with table Office 2010 32bit
Novice
mail merge with table
 
Join Date: Feb 2012
Posts: 3
nadja is on a distinguished road
Default

Hi Paul,,
Thanks a lot for your answer.

I've been working on this for a few days now, but just can't seem to get it right. I get page breaks where I don't want them & my data seems to be all over the place

It's also strange that suddenly also the formatting has changed (some of the data is now Arial instead of Calibri). Any idea why this would have changed?

Attached are the files I'm using, plus a word document "cust 2" which shows how I want my letter to look like for customer 2 - any chance you could help me out with this? Thanks a ton, I really really appreciate this & so do my nerves

If anything is unclear, please let me know.

Thanks again
Nadja
Attached Files
File Type: docx Cash Discount.docx (26.4 KB, 26 views)
File Type: docx Cust 2.docx (23.9 KB, 14 views)
File Type: xlsx Unearned Cash Discount January.xlsx (367.2 KB, 10 views)
Reply With Quote
  #4  
Old 03-05-2012, 04:36 PM
macropod's Avatar
macropod macropod is offline mail merge with table Windows 7 64bit mail merge with table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,225
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Hi Nadja,

With your letter, everything except the letterhead should be within the field code. You can see this in the worked example, attachmed to post #13 at: https://www.msofficeforums.com/mail-...nt-dollar.html.

For what you appear to be trying to do, the field code from the tutorial's 'Using an Extra Field to Generate the Trailing Text Per Group' example seems to be the one to use, as you have totals in columns L and N.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 03-06-2012, 05:40 AM
nadja nadja is offline mail merge with table Windows XP mail merge with table Office 2010 32bit
Novice
mail merge with table
 
Join Date: Feb 2012
Posts: 3
nadja is on a distinguished road
Default

Hi,
I have now changed my letter. But there's still 2 things I can't figure out.

1) I get a section break after each invoice and a page break after the total. Why the section break? How can I get rid of this?

2) Word seems to output some of the data in Arial, even though everything seems to be in font Calibri when I check my original letter. Any idea why or how I can change this?

Thanks.
Reply With Quote
  #6  
Old 03-06-2012, 05:41 PM
macropod's Avatar
macropod macropod is offline mail merge with table Windows 7 64bit mail merge with table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,225
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Hi Nadja,

1: That suggests you're using a Letter merge instead of a Directory/Catalog merge, as the Directory/Catalog merge code (correctly implementd) only generates page breaks between groups.

2: Probably because that's what font the relevant parts of the field code are in. In the mailmerge main document, press Alt-F9 to expose the field code, then use Ctrl-A to select the whole document. Apply the desired font format, then press Alt-F9 again to restore the field code.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Directory Mail Merge with table layout 3N1GM4 Mail Merge 11 06-03-2014 09:54 PM
mail merge with table Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
mail merge with table Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
mail merge with table Mail Merge to create specific number of table rows flackend Mail Merge 2 08-24-2011 11:49 AM
Insert formatted table into word (mail merge) manojbmsce Mail Merge 0 09-25-2008 02:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 PM.


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