A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Mailmerge Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Merge Field String Match Filtering by ken b
Very frustrated as can not make MERGEFIELDs work as every Help message I can find seems to indicate they should. I'm producing a directory but some people do not want their phone numbers or email info included, so in the directory, Excel DB, I included a field mask called "Hide" with the form...
November 13th 19 02:03 PM
by AmyRZimmermann Go to last post
2 815
Exclamation
Dynamic Index for Mergefields by M. Hummel
In a mail merge, I need to create an index based on a Mergefield. When I try this, I get an index with every page listed and the MERGEFIED rather than the field contents which generated in the mail merge. Is there a way to create an index based on a mail merge field rather than static text? I have...
October 25th 19 01:14 PM
by M. Hummel Go to last post
0 245
Why doesn't money sign show in mail merge? by Dressmaker
When I merge my database (using Excel) the money appears as text. How do I get the money to appear with the money sign?
September 3rd 19 07:38 AM
by MichaelCPurvis Go to last post
4 2,939
Add a clickable image with a specific link for each recipient in mail merge by P-Lab
I have been trying to figure this out with no positive outcome. Anyone with an idea or a solution, please share. P-Lab
August 7th 19 03:04 PM
by P-Lab Go to last post
0 447
How do I format a phone number in a mail merge field? by Halley
I tried the following, and it did nothing. I tried a few other variations, but they all gave me errors. { MERGEFIELD "PHONE" \"(###) ###-####"}
(Multi-page thread 1 2)
July 10th 19 09:57 AM
by liamrooker Go to last post
11 12,173
Retain / Reformat negative time from Excel to Word by Warrick
Hi There, Really need some advice here after cracking my head and searching for a long time. I have a negative time displayed in my excel sheet (e.g -01:22 mm:ss) which I would like to retain the format when I do a mail merge on MS word. However, the time gets converted to 01:22. I have tried to...
May 30th 19 10:46 AM
by neiljohanson Go to last post
1 1,119
If Then Else = Fail by MP1985
Never had this big a struggle with if then, but then I've never introduced a second variable. This works fine and dandy: { IF { MERGEFIELD f3 } = "Y" "{ MERGEFIELD f18 }" "{ MERGEFIELD f2 } (If party is a child, insert this name, if not insert that name). It's when I go for two conditions to...
May 30th 19 10:41 AM
by neiljohanson Go to last post
5 1,688
samsung printer error code u1-2320 by rosest962500
I want to share issues related to Samsung printer. Sometimes the issue may occur while printing important emails. Recover the issue with just one click, follow this quick fix guide samsung printer error code u1-2320. I had personally checked and had applied the steps to recover Samsung printer and...
May 18th 19 02:18 PM
by chothueaidaicuoi205 Go to last post
4 741
Formatting a field from a source with numbers and a sometimes a letter by shsnan08
Hi In my excel-sheet (source document) I have a column with ssnr in looking like "########-####" and some with "########-T###". The format in the column in excel is Custom "########-####". How can I merge this numbers in to my word document? Right now I have "{MERGEFIELD ssnr \#...
May 10th 19 12:21 PM
by shsnan08 Go to last post
0 405
Question
Word Labels, No Paragraph Break if Field is Empty by Jarrett
I have been trying to create some labels and some of my fields are empty. The fields that may be empty a Address_2 ; Address_3 ; Address_4 and County This is what my default MailMerge looks like at the moment: «Title» «Last_Name» «Company» «Address_1» «Address_2»
April 13th 19 07:32 AM
by Nayna Go to last post
4 1,621
Selecting which sheet to use from Excel VBA by BAC
XP pro, Office 2003 pro I am trying to automate a mailing from multiple Excel workbooks. Even though I have only 1 worksheet in each book, my routine still pauses waiting for me to select the worksheet before completing the merge, How do i tell Word to continue, using the only worksheet there,...
April 11th 19 12:43 PM
by Nayna Go to last post
7 3,453
Mail Merge pick up 2nd row containing Titles from Excel Worksheet by [email protected]
This is a simple question but I can't remember how to do this. First of all I am using Microsoft Word 2003. What I am trying to do is a mail merge from an excel worksheet. Normally I have no problems doing this but unfortunately the worksheet I was given does not have the Title row as the first...
April 9th 19 02:18 PM
by Sheri Wood Go to last post
7 4,818
Include a list of hyperlinks from excel in one mail merge document by ashelton1
I have a spreadsheet with a list of Salesforce reports (column A), URLs to those reports (Column B), and the names of the report owners (Column C). I want to send the report owners an email that shows a list of reports, each on its own line and each one hyperlinked to the report in Salesforce. Some...
April 5th 19 08:43 PM
by ashelton1 Go to last post
0 449
1 Attachment(s) Mail Merge Multiple data from Excel...Help!!!!!! by nicole327
Ok, so I am trying to send out letters to students showing them how many missing assignments they have. I want to transfer this information using a mail merge. Is this possible? Some students have 2 some have 4 or 5. I want to transfer what assignments they are missing and then have it move on to...
February 9th 19 12:23 PM
by mikkelkasper Go to last post
1 1,116
sdc-3100 3-part multipurpose labels by Martha Holmes
I have lots of Stamps.com 3-part multi-purpose labels and would like to use them. Does anyone have a templat for them for use in mailing?
June 20th 18 08:47 PM
by Carroll Hanks Go to last post
2 3,805
Cool
Mail Merge Simple Calculation Error by ZachG3
I am having an issue with trying to multiply the number from the database by 1.2 I think the issue might be that the number is coming through with a dollar sign in front of it (Ex: $343,000) and the mergefield may be reading it as text, rather than a number. Can anyone help with this? Thanks.
June 12th 18 04:16 PM
by ZachG3 Go to last post
1 799
Conditional with dynamic mergefields with quotes by mpaler
Hi all, say I have a conditional as follows: {IF {mergefield product_name} != "shipping" "{mergefield product_name}" ""} and the value output from mergefield product_name may or may not have a single or double quote in it (our product names can have a single quote for feet, or a double quote for...
May 1st 18 05:19 PM
by mpaler Go to last post
0 865
Printing on a postcard two sides using mailmerge by Anu
Hi, I already have the premade with blank information post cards. I am using mail merge to print the information on one side. I have to print the address on the back side of the postcard. How do I do it? I have seen several posts on this forum but could not find a solution. I am using word 2013....
January 23rd 18 06:30 PM
by Anu Go to last post
0 1,136
Format number with either 0 or 1 decimal place by FiFo
Hi I am trying to do a mail merge where I have no access to edit the original data. I have a field that currently sits to 2 decimal places but I want the figure to pull through with either no decimal place or 1 if it is not a whole number. I have tried using #.# which works for those with a...
October 9th 17 11:37 AM
by FiFo Go to last post
0 1,545
Insert page break in mailmerge using conditional rule by cody5679
Hello, I need help creating a statement to insert a page break in my mail merge based on conditions such as the name changing on the record set. I've seen examples on this weekend from back in 2005 but I couldn't get any of it to work in Word 2017. I need help!
September 22nd 17 10:06 PM
by cody5679 Go to last post
0 1,439
Post New Thread


Display Options
Showing threads 1 to 20 of 12022
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.