Hi there, I’ve got a standardised report that I’d like to send out to people per e-mail using mailmerge. This report includes arrow symbols. (eg, depending on a certain value, the report says, "your performance is up compared to last year" - and next to it there's the arrow showing upwards). Now,...

I am using MSWord 2007 Professional and I would like to be able to connect to a SharePoint List for information to use in MailMerge. I use Visio Profession 2007 and love the way it connects directly to Shareport Lists. Has anyone been able to connect MS Word to a SharePoint List? THank...

I am using Word 2003. I have my merged document and data fields. Some data fields are empty and I do not wish to print those records when the fields are empty. How can I do that?

I am mergingr ecords from my Excel datasource into a Word Mail Merge Letter with multiple records per page. All of the records come over into the document on the correct page but they do not space correctly. When I use the table format, I get a new table for each record on the page. If I do not...

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...