The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
14 views

Mailmerge 2 spreadsheets

Can I mailmerge in Word 2010 using 2 Excel spreadsheets? Have found article that says Get Data and then click Data Source but cannot find this in Mailmerge Wizard as an option.
0
votes
0answers
6 views

Mail Merge 2007 letter with data from multiple rows if same recipient

I am a novice mail merge user attempting to create a mail merge letter notifying students of incomplete work that must be completed over the summer in order to advance grades. I have an excel ...
0
votes
0answers
8 views

I need to pass a value to MS Word MergeFiled?

I need to pass the Revision Number to a Mergefiled in MS Word. TableStart:ClaimScoping{RevisionNumber='1'} There might be up to 7 revisions on every Claim Scope. I need to print revisions ...
-1
votes
0answers
26 views

VBA Mail merge save individual docs not working

I have this code which worked before, so I'm not sure what's gone wrong. As far as I can tell the code stopped working after I edited my template, but I can't find anything online about the template ...
0
votes
2answers
28 views

Microsoft Word Merge Field Problems

I'm doing a mail merge to a template with data pulled from an Excel table. I'm attempting to add text if the letter is for Program A or Program B, and different text if it's from Program C. The method ...
0
votes
3answers
20 views

How can I change the date format in MS Word 2016 to show only hours and minutes when mailmerging with an Excel file?

I'm trying to mail merge a MS Word letter with a MS Excel file which contains dates and times as well as other fields. I'm trying to put together for calling people to interviews at different times. ...
0
votes
0answers
19 views

CRM Dynamics 2016 MS Word 2013

In Dynamics CRM 2016 we have the merge documents. I do miss the former switch options. I saw you can manipulate the format in the docx by renaming to .zip and edit the xml... but what to do? I want to ...
0
votes
0answers
25 views

Is it possible to mail merge a tables from the database into word?

I'm trying to use MS Word as an alternative to some basic reporting using mail merge from an MS Access database. I'm able to do basic mail merge with fields from one table. What I want to do next is ...
0
votes
0answers
39 views

Word Mail Merge - Filter Based on Partial Match of Text?

I'm using Word 2010 and Excel 2010 to do a mail merge. In the spreadsheet, the Employer field has variations of the employer name, such as: - SkyScraper - SkySraper Inc. - SkyScraper Mexico In ...
0
votes
0answers
21 views

How do I attach a PDF document to Outlook 2011 mail merge on a Macbook?

I want to generate e-mail message of letter form as HTML and add a PDF document as an attachment to the message. How can I do that?
0
votes
0answers
31 views

Outlook 2010 E-mail Merge

We need to send over 100 e-mails out to different recipients with an attachment. Is there a way to create an e-mail merge so that the same document is sent to hundreds of addresses. Similar to mail ...
0
votes
3answers
66 views

Printing multiple sheets with Mail Merge (Excel/Word)

I need to create letters with MS Word. On each letter we need a code which is placed on the letter using Mail Merge. Some letters need to be printed more often than others. I need to find a way to ...
0
votes
0answers
102 views

Word Mail Merge with Excel - Can't open both at the same time

I have a word mail merge for letters using an excel file as the data source. My problem is that I am not able to have both files open at the same time for editing (i.e. the excel source data and the ...
1
vote
1answer
42 views

word - merge mailing with specific fields if another specific field has a certain value

I want to do a merge mailing and I got the following issue My word document is on the screenshot capture below I want to put specific merge fields like adr_A1 in Adresse1when my specific field,...
0
votes
0answers
54 views

Automatically scale font size to fit text box

I am currently setting up a mail merge but I need the size of text in a text box to scale. I want the font size to be the biggest I can whilst fitting in the text box. I've searched around, but I ...
0
votes
0answers
51 views

Mail Merge Multiple IF Conditions for cell

I have a conditional statement for two cases (and default) which works fine. This is simply to enter a cell value based on another cell value in an earlier column simplified and shorm of extraneous ...
1
vote
0answers
25 views

Mail merge record not stay next to others, split by Section breaks [closed]

I have a picture with an text field inside it. I want to use mail merge to auto fill this textfield with 20 different numbers. When I use mail merge, each record stay in a page, and split with the ...
0
votes
0answers
21 views

Microsoft Word for Mac adding shadows to merge fields

I recently installed Microsoft Word for Mac (2016), which seems to be a vast improvement over previous Mac editions. However, after creating a graphically complex (lots of shapes and text boxes) mail-...
1
vote
1answer
23 views

How to pull addresses from word to use in Mail Merge?

I am trying to figure out how to pull addresses from a Rich Text Doc. in Microsoft word to use the mail merge in Microsoft Access. This is being used for work and I need something as quick as possible,...
0
votes
1answer
404 views

How to concat mail merge IF fields in Word 2013

I have Word 2013 and I have a need to display a piece of text only if a mail merge field equals 1. Simple: { IF {MERGEFIELD Discount} = 1 "You get a discount" "You don't get a discount" } However, ...
1
vote
1answer
29 views

Microsoft Word 2010 mail merge - statement overdue calculations

My company hosts various events for clients (conference meetings, receptions, holiday parties, etc.). After an event is completed, we send out invoices. Monthly we also send out statements for all ...
0
votes
0answers
15 views

How do I set conditions in a mail merge in Publisher 07?

I want to do a mail merge where if a field is blank or empty, something else should be printed. How do I do that? Also, I used a mask for inputting phone numbers, but they are coming out 1234567890, ...
0
votes
0answers
72 views

MailMerge change Picture Size [Word2013]

I have a word document witch I'm using as a Template for my MailMerge. My problem is, that when I insert the Pictures into the document the pictures are too big. I want them to have a 50 px width (...
0
votes
2answers
450 views

Word 2010 Mail Merge Suppress Blank Conditional Mergefields

I cannot get a conditional Mail Merge to suppress blank lines in a relatively clean and efficient way. The only solution I have found is one I am not willing to use yet as I feel there may be a better ...
0
votes
0answers
208 views

How to mail merge in a protected document or simular

I'm trying to do a mail merge with protected templates which Microsoft will not allow for some reason does anybody no of a work around or an alternate solution. The reason it is a protected document ...
0
votes
1answer
460 views

Mail merge alternative

I have a template Word document which I use when writing supporting technical documents to send with CAD drawings. Due to the nature of the product we create, this accompanying technical note is ...
0
votes
0answers
46 views

MS Word 2013 Mail Merge: I can't seem to make it retain formatting

I am doing a merge in MS Word 2013, I have a part of the document that says: Dr. «Contacts_Last_Name» When I Toggle Field Codes, it says: Dr. {MERGEFIELD Contacts_Last_Name} I have tried to format ...
0
votes
0answers
36 views

Is there an equivalent to CTRL+F9 in Microsoft Publisher 2007?

I'd like to be able to edit the fields in my Microsoft Publisher based mail merge. In MS-Word there is a feature where you can press CTRL+F9 and add things like if statements and images instead of ...
2
votes
1answer
3k views

How do I attach a PDF document to an email merge using Outlook and Word

How do I attach a PDF document to an email merge using Outlook and Word. The merge is ready to go but I don't see a place to attach a file.
0
votes
0answers
31 views

3-level Mail Merger

I need to do a 3-level mail merge in Word 2010. I have done to 2-levels(with the help of these documents https://support.microsoft.com/en-us/kb/211303, Mail Merge - Multiple Rows Into One Document but ...
0
votes
1answer
23 views

Changing current mail merge to use new source data

I have a mail merge file that I created last year, I would like to use a new source data file to create new post cards. Can this be done and how do I go about doing it? I really don't want to create ...
1
vote
1answer
230 views

Multi-line merge fields and line spacing

A database field contains several lines. When the field is merged in the Word document, each line becomes a paragraph, therefore each of them get the paragraph spacing. Example: «my_merge_field» ...
2
votes
0answers
128 views

Suppressing Blank Mergefields in Word 2010 Mail Merge

I'm working on combining two mail merge letters into a Master template that will know which merge letter to populate based on information in a specific column. I have successfully combined the two ...
1
vote
1answer
54 views

Libreoffice: Import columns of spreadsheet as fields

I have a LibreOffice Calc spreadsheet with Columns A, B, C. I would like to create a document in LibreOffice Writer with format: A1 B1 C1 A2 B2 C2...
0
votes
1answer
201 views

adding image from excel to word using mail merge

I'm using mail merge to generate a word document from an excel sheet and some cells contain images (office 2013). Is it possible to export them as well to word directly with mail merge without putting ...
0
votes
1answer
145 views

Mail Merge comparison between fields

I have a meeting merge document which is populated from a CSV file with data entered online from a facilitator. I am unable to work out how to do multiple conditions, there are a maximum of 10 clients ...
0
votes
1answer
54 views

Retain email subject when sending mail merge via Publisher 2010?

I am using Publisher 2010 to send a mail merge via email. I choose "Finish & Merge" and then "Send Email Messages..." and finally, after entering a Subject, hit "Send." No problem! The expected ...
1
vote
0answers
47 views

Need to Selectively Merge Records to Different Places in a Word Directory-type Document

My company regularly creates "rosters" (or directory documents) that list contact info for people with roles for a trust fund. The rosters have a certain format -- people with an "Administrator" role ...
1
vote
1answer
127 views

Incorporate Excel formula Names in Word Mail Merge document

I have an Excel document with numerous constants defined in Names. For example: ------------------------------------------- / Edit Name ? X \ |-------------------------...
0
votes
1answer
285 views

Word mail merge and page breaks

Looking for a way to put a page break after a number of rows in an Excel data source for mail merge in Word - the number of rows before the page break can vary, depending on he number of records that ...
0
votes
1answer
487 views

Word 2010 - Mail Merge multiple conditions

I am attempting to get mail merge to process certain conditions eg: if mergefield spouse = 1 and mergefield lawyer = 2 and mergefield children = 3 and mergefield parent = 4 add certain text or if ...
0
votes
0answers
45 views

How to retain formatting from other Word 2003 documents?

I have set up a master document in Word 2003, using numerous IF Fields. It has been set so that if mergefield = xyz in my database, then it uses document 123.doc (which has been set up separately). ...
0
votes
2answers
189 views

Identifying and Replacing French Characters in Excel for Email Value

How do I identify the character é in a value and replace it with e? I am using Excel to hold data for a MailMerge. Each column represents a piece of data that is either used in the MailMerge or ...
0
votes
1answer
795 views

Mail Merge using mutiple fields/next record

I am trying to merge the following: {MERGEFIELD Signer} Date Page 2 {MERGEFIELD Payername} {MERGEFIELD Number} {MERGEFIELD Description} {MERGEFIELD Year} PB If the client has multiple Payer ...
0
votes
1answer
163 views

Macro to merge data on to template

I am attempting to basically do a mail merge in Excel. I would like to take employee data from one Excel worksheet and populate fields on an Wxcel template. So far I have written code to open the ...
0
votes
1answer
2k views

mail merge to separate documents with filename based on Merge field

I'm doing a mail merge from a Access database and I'd like to make many documents from the mail merge, instead of just one. I found a macro that lets me split the merged document after it's made, that ...
0
votes
0answers
252 views

How do I turn html tags in word to formatted text

I'm trying to make multiple documents using mail merge and an access database, but there is one field where in Access I have it saved as rich text. I need it as rich text because it's a single field ...
0
votes
2answers
2k views

Mail Merge Multiple Rows into one document

I have an excel file with different fields in each column: Field 1__ | Field 2__ | etc. F1 Item 1 | F2 Item 1 | etc. F1 Item 2 | F2 Item 2 | etc each field has a different number of items in it. ...
1
vote
1answer
112 views

Mail merge - Change data in source from merged document

I have an excel file with thousands of records. I want to mail merge and build a directory which I have done. The problem is when directory was built I noticed that there were some errors. I want to ...
0
votes
3answers
14k views

How do I stop a mail merge from adding zeros to the end of amounts of currency?

I am using an excel spreadsheet as my data source in a Word document mail merge. I have formatted the amounts in excel as currency with 2 decimal places. When I complete the merge, the amounts have ...