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?

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.

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

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

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

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!

Hi Guys Im new here, But found this site through a search. I dont know if its possible but i have a mail merge document with over 2000 pages, my printer has the option to staple, I'd like my document to staple every 3 pages together. We are using word 2010, Does any body know it this is possible...

Hi, I'm pulling my hair out trying to do something that should be simple, but is turning out to be difficult. I have these name badges I need to create that are white with a blue logo on top. I included a sample (with the logos blurred out) to give you a visual. https://ibb.co/cSs3H5 Basically,...

Hello, I need to make a mergefield that returns a large value display as text. I have read and tried every single response on this site, as well as the sites of the contributors where possible. I am still unable to make this work. When I try the suggestion below, (both copied and typed manuallY),...

Hi- I'm trying to add two mailmerge fields that are dollar amounts. However, each record may only have one field, not both. How do I create a formula for a field to add the amounts when one might not even be there? Thank you!

Hello all, I am using Office 2013. I need to make item identification labels for bins we have on our shelves. I created a list in excel (.xlsx) of 200+ items that I need to merge into word for my label template. I start with a fresh blank document. I then proceed to Step-by-Step Mailmerge wizard....

I've read a number of posts to remove a line based on a no value being returned but can't find out how to remove based on a specific value being returned. e.g. I have a merge line below where 'UK Equity' is text UK Equity { =100* { MERGEFIELD BenchUK2 } \# "0.0%" } Currently, if the value...

Hi all, I am trying to perform a mail merge into word using data from excel. The data is exam target grades and review grades which are colour coded according to progress made (red, amber, green and so on). Is there a code I can use to make the colour coding appear in the word document? The...

Hi Tried many times and got as far as this but no success I have added image with my formula but does not work for me, sure its wrong, just need some advice? Thanks Steve

I would like to able to change the text colour in a mergefield based on the returned value. For example, if the returned value is "A" I would like to change the text colour to Yellow. Is this possible

hi could someone please help me with an if statement heres the scenario example: DESC UNITPRICE BLANK 0 TSHIRT 0

I cannot figure out why my decimal is being messed with for the following mail merge math: 5.375% x $8,213.28 = $441.46 (is what the correct match should be) My merge fields a { Mergefield Interest Rate } x { Mergefield Balance } = {= { Mergefield Interest Rate } x { Mergefield Balance }/100...

I'm working on a mail merge to create a letter. It includes a table within the letter. A student can have 1-many rows in the table depending on the aid they are receiving. What I am trying to do is list some date ranges for the column headings and then below is the amount of aid per each type of...

Hi, I have been asked to produce a letter in mail merge that has a response due date within it (2 weeks from day of printing), unfortunately the database that I am using I cannot calculate it and add it as a new field as I cannot change the date within it. Is there any way to calculate a date...

I have a Mail merge document that I need to Add Optical Marks to so that my automatic letter stuffing machine can tell how many pages there are in each document. THE OMR can be the underscore character.