 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / May 2004NEW USER needs to extract name and insert in letter after 'Dear'
Added more detail to my original posting >> I need to extract name and insert in letter I have written. >> After the 'Dear'. I have my original database queries in >> Access as well as the Mail Merge label files I created. >> >> I have used Access and Word Mail Merge for 2 months and >> am fairly good but I have never done this before. In the access queries I created each column holds data like FirstName LastName Title. In the Mail Merge Label documents I created, each box/label has fields specific to the user. Like an address label. I have figured out how to create a table and I even populated it with a names I took from an Access queurie using Mail Merge Wizard. The problems I have are two. 1 - When the layout is carried forward and all the letters tables after 'Dear' are populated with names, I see that the sorting I did in in the querie, and in Mail Merge Wizard has been ignored. I have every name, included those I do not want. 2 - Dragging the table to where I want it on the page (after 'Dear') is way more difficult than it should be. Looking forward to responses! Any tips/walks thru How To would be appreciated! Thank you >-----Original Message----- >Is each of your names&addresses in a single field in your Access database? >Or are they divided up into stuff like FirstName, LastName, Address, City, >etc.? <anonymous@discussions.microsoft.com> wrote in >message news:1230001c44271$5ce844c0$a101280a@phx.gbl... Can you try to spell out what data you have and where you want it to go in the ouput from your merge? It sounds to me as if you are trying to do a merge using one data source , and are perhaps inserting a Database field or something in order to do something like Dear <<person>> Here is a list of people assigned to you <table containing one row per person assigned to the <<person>> > If so, you will need to modify the WHERE clause in the query in the DATABASE field so it filters on <<person>>. But I'm just guessing at the moment.  SignaturePeter Jamieson > Added more detail to my original posting > [quoted text clipped - 39 lines] > <anonymous@discussions.microsoft.com> wrote in > >message news:1230001c44271$5ce844c0$a101280a@phx.gbl... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.