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
Conditional Formatting of background and text by KevinMoses
Greetings all I have created a mail merge document from a spreadsheet. One of the merge fields captures Residual Risk Ratings. I am trying to create an IF statement in order to use the following conditional formatting: Extreme (Pink shading, white text) High (Red shading, white text) Medium...
August 21st 13 01:56 AM
by K R Go to last post
2 7,984
Round Down Merge field by Niall
Hi I have got the following field in a mail merge document: {={MERGEFIELD Annual_Rent}/4} I am trying to round down the result to 2 decimal places and tried: {=ROUNDDOWN({MERGEFIELD Annual_Rent}/4,2)}
August 19th 13 09:05 PM
by 4zelka4 Go to last post
2 4,400
NEED HELP !!!!! Add another formula to the Mail Merge Forumla IF by Adi.Master
Hi.. I am new to this forum and have one question thats been bugging me since a month... hope to get a satisfying solution... I have a template which inputs data from an excel sheet.... I have entered the IF formula as follows: {IF {MERGEFIELD State} = "A" "My Paragraph 1" "{IF {MERGEFIELD...
August 18th 13 11:34 PM
by Adi.Master Go to last post
0 1,785
Multiplying a mail merge formula by Grazza215
Hi guys, Really hoping someone can help I've been trying to get this to work, but seem to be missing a trick. I am using a series of mergefields (linked to a CSV data sheet) and have this working fine: £ { = { mergefield "debits_H"} - { mergefield "EXPCT_AMT2"\#,0.00 } + { mergefield...
August 13th 13 04:42 PM
by Grazza215 Go to last post
0 2,643
Insert variables into mailmerge documents by Force
I have the following code that I am attempting to print labels with. The code to identify an individual will be the same for all labels. What I am using the mailmerge for is to cycle through the various labels that we are creating. I am trying to print out the variable finalOut with a CFLR at the...
August 5th 13 06:00 AM
by Force Go to last post
0 1,694
Getting a sentenced inserted into a letter. by Greg D Isringhaus
I am needing to know how to make a rule that has 3 different variables. I need a rule to enter just one sentence. Basically need a formula that reads: If "Exception" = "Y" and "Disease" = "Y" and "Age" = "Y" then "paragraph to be inserted." I just can't figure this out, I'm sure that it is...
July 23rd 13 05:52 PM
by Greg D Isringhaus Go to last post
0 1,654
Blank Line with If...then...else field by jmh117
Hello, I'm trying to create a document that will have one address block when the field Agent in my source document is "self" and two address blocks when Agent is not self. Currently I have the following code for the full address (not using the address block function as I have two addresses in...
July 3rd 13 03:01 AM
by jmh117 Go to last post
0 2,023
Mail Merge Makes One Page of One Name of One Label Instead by Little23
I am trying to do a mail merge for address labels using Office Depot white address labels that are the same size as Avery 5160. When I put in the Merge Fields, I then go to the Finish Merge and select Edit Individual Documents and then select all. Instead of using each label section for the list of...
May 30th 13 04:43 PM
by Little23 Go to last post
0 1,791
how do i print place cards by vicki
I am printing place cards for wedding shower - do I use mail merge or can and how do I access the template that I downloaded from place card site?
May 28th 13 04:43 PM
by IsaacLindsey Go to last post
2 6,320
Red face
Mail Merge Functionality by Doga
I am getting below error when i click on the Mail Merge button in code -- Method 'Run' of Object '_Application' Fail amd it is asking for the password code is as below Private Sub MergeMailDoc(as_Path As String, as_DocName As String, as_Where As String) Dim ls_DbConnection As String Dim...
May 22nd 13 07:28 AM
by Doga Go to last post
0 1,553
save merged document from c# without opening word by tom
Hi, I would like to save a merged document to disk, without opening word. The merging works fine if I make word visible and let the user save the doc, but if I try to save from code without showing word, i get 'Opening this document will run the following SQL command'. The code I use is as...
May 21st 13 03:06 AM
by talerKK Go to last post
6 6,401
excel - word - outlook -2007 mail merge problem by andy4u
Hi guys , I have got email id's in excel sheet ... i am trying to merge it with word 2007 and send email through outlook 2007 Now what happens lets say i have 2000 email id when i start sending/uploading mails in outlook after some email id , Emails stop uploading in outlook outbox and word...
May 17th 13 01:45 PM
by andy4u Go to last post
0 1,681
Conditonal Mail Merge statements by Admin Asst Extraordinaire
Hello! I am trying to use Mail Merge to make customer lists for various contractors. I need to know how I can make the list on a single page for one contractor, then start a new page for the next contractor. For example: Say ABC company has 4 customers in the list, I want them all on the same...
March 27th 13 07:38 PM
by Admin Asst Extraordinaire Go to last post
0 1,755
Saving Filter Parameters by Alajane
I have to merge Access and Word files often. The Access file Iím using has a lot of fields and I quite often need to merge different documents using the same filters. Iím currently merging about 20 documents that will all need the same six filtersóit takes quite a while to scroll down to...
March 19th 13 07:52 PM
by Alajane Go to last post
0 1,527
MailMerge from Excel Spreadsheet by suzshook
I am trying to run a MailMerge from Word using an Excel Spreadsheet, but every time I try, I get an error in Word which becomes unusable. It stops working, but I have to remove it using Task Manager. If I click on View Problem Details when I get the error, it says the error is in the EXCEL32.CNV...
March 8th 13 05:32 PM
by suzshook Go to last post
0 1,573
Word Fields by DrewL
I am trying to set something up in Word to automatically update titles. Name Title Phone Name would be a drop down, and based on the selection, title and phone would update appropriatly to the name selected. I can not seem to figure this one out. I am not well versed in VB.
March 8th 13 02:12 PM
by DrewL Go to last post
0 1,552
Merging into text boxes by lukestkd
Hi all, I'd like to know if you can, and if so how to, mail merge into text boxes for label sheets with multiple labels on a sheet. I am making target stickers for my students, and the I cannot find a way for the layout of the sticker to work without using textboxes. Top left label is what it...
February 21st 13 01:33 AM
by lukestkd Go to last post
0 1,824
mail merge (word 2010) cuts off the text after 255 characters by Giolina
hi this is located in SHEET1 of the Workbook: No.............................HEADER-A.........................................................HEADER-B...................................... 1..........cell with garbeld text (over 1000 characters).....................cell with garbeld text (over...
February 12th 13 05:51 PM
by Giolina Go to last post
0 2,625
Calculations with possible null value fields by JR042
I'm trying to perform the following calculation in Word 2007 mailmerge, using a txt file (with line return record delimiters and vertical bar | field delimiters) as my data source but I keep getting a syntax error if any of the fields have null values: R1 + C1 + M1 I can use IF statements to test...
February 7th 13 02:45 PM
by JR042 Go to last post
0 1,648
Custom label formatting by ittim
Hi All, I've run out of patience on a project i'm working on. I need to mail merge some info onto some cards which have fields in pre-detrmined places. so far i've managed to take an image of the layout and set it as the background and also set out a custom label. I assume I need to use tables...
February 4th 13 03:37 PM
by ittim Go to last post
0 1,555
Post New Thread

Display Options
Showing threads 101 to 120 of 12037
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 04:11 AM.

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