Hello, I'm trying to create an if/then merge based on the following logic... If Condition A = true, output "• string A", else check for Condition B If Condition B = true, output "• string B", else check for Condition C If Condition C = true, output "• string C", else check for...

I have a basic mail merge letter and I want to include images from a folder that are named as a mailmerge field. I have used the following code {INCLUDEPICTURE "C:\{ MERGEFIELD "PLACEREF" }.TIFF \* MERGEFORMAT \d} The picture stored under the C drive is named as the placeref of the mail merge...

I know nothing about how the mail merge works...but I use it on a day-to-day basis and was thinking there has to be a better way. Currently, we have mail merge set up in a Word 2000 document that will run a query and pop up a box asking for the ID of the record to pull, the data for that specific...

I can't seem to find an answer to this, but it may exist elsewhere. I am trying to create a packing slip using a Word doc using an Excel sheet as the merge source. On each row of the Excel sheet, I have the recipient name, address, etc and at the end of each row, i have 8 rows that list a quantity...

I set up a Directory Merge document and now all my merge documents are directory merge documents, which means I have to merge data before I can preview results. How can I turn this option off and restore my documents to normal mail merge documents?

I am developing a user friendly application utilizing Excel VBA to create and process a database to be used as the source of data for a Word mail merge. From Excel, the user may choose to create one of 16 different documents based on the data in the database. The 16 different documents are based...

I am trying to automate word mail merge from access, but when I open the mail merge document it comes up with a warning: "Opening this document will run the following SQL command Select * from (and then the text file which merges with the word document). How do I automate it so I do not have to...

In my attempt to create a directory type document in mail-merge how can I prevent an address block from over running the page. I want each block that will not fit on a page to start a new page. Thanks.

We use GoldMine 4.0 for our contact manager and I am trying to install the link to have it print letters and envelopes in Word from GoldMine screen. I cannot find the GMLink.dot file to enable macros and install the ODBC driver.

My user has created a mail merge in Word 2010, using Excel 2010 workbook as source data. One of the many fields is called "Survey Link" and contains links to Sharepoint pages, either a DEVELOPMENT page or a PROJECT page. When the hyperlink is created in Word and the merge field is entered as...

I am trying to populate Avery 5160 labels by using a file with contents like this (semicolon-delimited, one record per line): Mr. Joe Brown; 123 Cypress Lane; Sausalito; CA; ;;; 54567 Mr. Merle Haggard; 456 Fiddlestix; Redding; CA; ;;; 55555 Does anybody have step-by-step instructions on how to...

My boss just ordered promotion letters (standard 8.5" x 11") with two areas left to print our customer list/database into. The first area will be shown through a windowed envelope and the second is in the bottom right hand corner of the page for the return mailer. Both addresses will be the same...

Some addresses need only one line before the city and state, that is, they only need an Address 1 field. Other addresses require two or even three lines so I have had to create an Address 2 and an Address 3 field. Unfortunately, this means that when an address that has no data in Address 2 or...

So I am making address labels from an excel sheet. I can mail merge no problem in Word when I have under 30 labels (Avery 5160 label is what I am using, fits 30 on 1 page) fits all on 1 sheet of labels. When I try and merge an excel sheet that has 160 addresses I am only getting 1 sheet of 30...

I have been asked at work if there is a way to send the same email out to multiple recipients. However, the individual recipients must not see each others details. Is this possible by setting up a mailmerge in Word? Thanks Paul

Hi all, I am trying to perform a Directory type Mail Merge from Excel into Word where the data being referenced in Excel has repeated values in one column which I effectively want to group on so that I produce one document per value in that column instead of one column per record in the...

I am using the lastest version of the mmtodocs on word 2010 i am having the problem where its inserting a next page section break at the end so i am getting a blank page. Both the merge template and the normal.dot have the same margins and set to a4 still nothing Any ideas? I cant get to the...

Hello, I've got a mailmerge document getting data from Excel (with Microsoft Office 12.0 Access Database Engine OLE DB Provider (Ufff, the longest name on the list ;) )) in Office 2010. Now, I had to move the Excel file with data and I'm trying to update data link accordingly. Every time I Open...

I have gone through all the normal steps. The data source is an excel spreadsheet and is correctly identified. When I look at the recipient list they are all there in order. All the necessary fields are matched. However, the new record field that is automatically entered for each label...

Let's say I have the following excel file that has NAME (customer account name), ORDER # and order DATE. (I can convert this to an Access file if better for my application...) http://i67.photobucket.com/albums/h292/jkilday4/DummyexceltableforumquestionB40212-1.jpg As you can see, some account...