Super User
Super User

Questions tagged [mail-merge]

Use this tag for questions relating to the automatic addition of data from a database or spreadsheet to documents/letters in Microsoft Word. Mail merging is often used in order to facilitate sending similar mail to many addresses.

Use this tag for questions relating to the automatic addition of data from a database or spreadsheet to documents/letters in Microsoft Word.

Mail merging is often used in order to facilitate sending similar mail to many addresses.

This could also cover questions relating to merge fields or field codes as there is crossover between these topics.

215 questions
15
votes
7 answers

Remove mail merge data source from MS Word Document

I am using Microsoft Word 2013.  I have a document that, when opened, prompts me with: Opening this document will run the following SQL command: SELECT * FROM C:\somepath\somefile.mrg Data from your database will be placed in the document.  Do…
CoolUserName
  • 479
7
votes
1 answer

Word mail merge: show or hide table

I'm creating a mail merge document where I need to hide swathes of the document based on a field I have. OK. That's simple enough. {IF {MERGEFIELD My_Field} = "True" "a bunch of text ""}. But one portion of the document I need to hide contains a…
Casey
  • 302
7
votes
4 answers

Multiple mail server provider for one domain is possible?

I have searched in google before asking here. I got a mixed answer in google. Can i have a multiple MX record from different mail providers? Example, Zoho Mail user1@example.com user2@example.com Google…
Mehul Kumar
  • 179
6
votes
2 answers

Microsoft word - conditional formatting in mail merge?

Is it possible to use conditional formatting in Microsoft Word 2007 Mail merge? I would like it to color the font, depending on the field value, for instance: if "Priority" field equals 1, color the font to red if "Priority" field equals 2, color…
dstronczak
  • 218
6
votes
2 answers

Changing Word mail merge data source locations in bulk?

I've just moved a number of Word mail merge files, and a number of Excel spreadsheets that are the data sources for the mail merges, from a Windows XP computer to a Windows 7 computer, and now all the paths for the merge sources are incorrect (used…
Daft Viking
  • 61
4
votes
2 answers

mail merge e-mail in Word 2007 with attachment

Is there a simple way to mail merge with Word 2007 and add an attachment? I've searched google, and all results point to pasting in VB code. I want to a small team of novice users to be able to mail merge e-mails and add attachments. Does anyone…
falter
  • 2,097
4
votes
3 answers

In Word 2007 how can I set up a repeating section for Mail Merge

In Word 2007, I want to set up a mail-merge template where multiple rows from the data-source will appear on a single page. So, something like this: ---Page-Boundry-------- Header blurb 1 Header blurb 2 Header blurb 2 …
d4nt
  • 143
4
votes
1 answer

Mail merge from Excel to Word: field is formula referring to text >255 characters

I am trying to perform a mail merge from an Excel document to a Word document. The fields in the source document retrieve text from elsewhere in the Excel document. Thus, the actual fields are in fact formulae. The content of the fields is plain…
CaptainProg
  • 708
  • 4
  • 14
  • 28
4
votes
1 answer

How to Split and Rename files by Mail Merge Field

I just finished a letter MAIL Merge on Word and would like to: Split the documents into separate WORD documents, and Save or Rename the files by 3 different mail merge fields. I am not familiar with Macros or coding of any kind. Is there an app…
ad82688
  • 41
3
votes
0 answers

Excel/Word on MAC - includepicture containing url

I have the following: A excel spreadsheet with names and url's to a QR code, each in a column of the spreadsheet. The url returns a jpeg picture of the QR code. A word doc where these names and pictures should merge into, and then printed as…
jens
  • 141
3
votes
2 answers

Labels mail merge repeats on subsequent pages?

I'm trying to do a mail merge to print to labels. The first field in the document does not contain a { NEXT } field code, and because of this the records repeat between label pages for example: Notice how the records shift to the left as the…
leeand00
  • 23,552
3
votes
1 answer

Word 2007 prompts twice for "Opening this document will run the following SQL command" for Mail Merge

I am trying to figure out why my mail merge in the a Word document is prompting me twice for seemingly two different data sources. Both prompts look like the following: . The first prompt points the path where my .csv file resides, but then the…
Chad Harrison
  • 6,229
3
votes
2 answers

Word 2010 - Mail Merge with Superscript Formatting

I have a user with a letter in Word 2010, built for a mail merge. The source document for the addresses is another Word document. The source document includes addresses that have super-scripted street names. (ie. 77 1st Avenue) When we do the…
dangowans
  • 2,010
3
votes
3 answers

retain formatting from source document in mail-merge

I have set up a mail-marge in Word 2003. The source is a document where each field is a formatted text as the following one: I have different pieces of text to insert. However, when I insert such a Merge Field in my primary document, it losts its…
Toc
  • 1,821
3
votes
2 answers

Generating a pdf using data rows from excel and an image as the template with placeholders

I have lots of data rows in excel, each row has columns such as first name, last name, gender...etc. I also have an image as the template, I would like to define some placeholders on it. And then for each data row, an image will be generated by…
bobo
  • 1,869
1
2 3
…
14 15