|
|
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»
|
|
3 |
531 |
|
|
Mail merge with several conditions by
Etheldawg
Hi all,
I hope someone can help me. I cannot figure out how to get this to work. I need to have three different signatures based on the amount of a gift and some other information.
If the gift is $1000 and below, the signature is person 1.
If the gift is between $1001 and $2500, the signature...
|
|
4 |
1,204 |
|
|
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...
|
|
1 |
593 |
|
|
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?
|
|
2 |
3,206 |
|
|
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
|
1 |
460 |
|
|
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...
|
|
0 |
418 |
|
|
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...
|
|
0 |
475 |
|
|
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...
|
February 19th 18 03:44 AM
by MP1985
|
1 |
850 |
|
|
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
|
0 |
693 |
|
|
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,...
|
|
6 |
2,750 |
|
|
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
|
0 |
1,063 |
|
|
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!
|
|
0 |
924 |
|
|
Mail Merge 2000+pages by
Gazzaman22
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...
|
|
0 |
975 |
|
|
Creating Labels Over 3-Up Image by
dEaF TO LiGhT
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,...
|
|
1 |
1,050 |
|
|
\*DollarText with Large Values by
Hulan
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),...
|
June 29th 17 03:24 PM
by Hulan
|
0 |
952 |
|
|
Sum of two fields with possible blank option by
Angie O.
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!
|
|
0 |
700 |
|
|
|
June 24th 17 08:43 PM
by Varda
|
9 |
9,733 |
|
|
Mailmerge failure by
bobgrand
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....
|
|
0 |
786 |
|
|
Delete entire line base on a returned value by
Nightofthehawk
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...
|
|
0 |
4,102 |
|
|
Mail Merge Conditional Formatting with Colour by
JO GS
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...
|
December 5th 16 11:17 AM
by JO GS
|
0 |
2,163 |