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 Excel/Word 2007, getting 12:00AM in merge which is NOT in ex by Onalee
Hi, I am merging data from excel into a word document. I am getting data in word that is showing "12:00AM", however, there is data in the excel sheet and it is NOT a date and it is not blank - it is part of an address line, such as "Deliver to Front Desk" or any kinds of words, but definately...
(Multi-page thread 1 2)
December 23rd 08 02:48 PM
by Kelly Dennis[_2_] Go to last post
13 1,760
Update All Labels results in skipped labels by Tom G
I've reviewed and followed the posts suggestions on this issue but still only the first and last rows of labels to display records. I'm using Word 2003. I created a clean spread sheet of only 17 rows . There are no long addresses. When I complete Select Your Data Source the first label is blank...
December 23rd 08 08:26 AM
by Peter Jamieson Go to last post
3 1,234
combine column data into a row by SMC
I am attempting to email clients that have mulitiple patients (animals). Instead of sending each client numerous emails I would like to combine the patients into one email. Is there a way to combine the names that show up in different rows into one row?
December 23rd 08 02:34 AM
by Doug Robbins - Word MVP Go to last post
1 1,028
Mail Merge - If statement by Nieve
Hi I have a mail merge letter to send to potential clients. Some of the data in one merge field (Contact Name) is 'No Contact'. I want to set a rule in the mail merge template that says when the data 'No Contact' is merged it is replaced with 'The Manager'. Is there a way of doing this?
(Multi-page thread 1 2 3)
December 22nd 08 11:38 PM
by Peter Jamieson Go to last post
21 2,652
Mail Merge / excel by Barry Baker
I have a mail merge document that works fine except a couple of the field are a percentage field , in excel i have formated it to 2 decimal points but wen it merges to work, it show the whole number which is about 15 digits any idea how to make it just the tow. is ok in excel but not in word
December 22nd 08 11:29 PM
by Pat[_4_] Go to last post
9 1,482
Formatting Date - not working for me by Pat[_4_]
Hello, I am pulling in a date from Excel and it is formatting as a number. I have searched and see the example of { Mergefield Birthday \@ "MM/dd/yy" } -- Thanks, Pat
December 22nd 08 10:45 PM
by Pat[_4_] Go to last post
3 904
Using AND in a field code by Simon
I'm trying to use field codes, and distilled down to a test case with a formula embedded in the first IF expression: {IF {=AND(12,13)} = 1 "OK" "BAD"} Looks simple enough - but I can't get this to display 'OK' - even when I update the field. I did see it work - but now it's gone again. Seems...
December 22nd 08 09:51 PM
by macropod[_2_] Go to last post
2 991
mail merge by Debbie
I have 981 names that I am merging from Excel into MSWord to create labels for our mailing. Everything says it has merged but only the first 30 names on the list will print...does anyone know where the other 600+ names are? I can't find them and it is frustrating...thanks,
December 22nd 08 04:36 PM
by srctr Go to last post
2 911
Numeric Formate by dorothy
Hi, I want to display numeric numbers without spaces: e.g. 1) if Price 1000, e.g. 12.3, then it is displayed as "12.3" 2) if Price = 1000, e.g. 10003, it is displayed as "10,003" However, if I format is as : {Price \# ,##0.0} 1) will be displayed with spaces. e.g " 12.3"
December 22nd 08 10:48 AM
by dorothy Go to last post
3 928
Formatting Mergefiled Problems by malycom
Hi I have looked up and found lots of similar problems with this but I haven't found a specific answer. By the way, this is the first time this problem has happened to me and I have done dozens of merges so I don't know what's happened. Firstly, my merged data from Excel is inserting a 0 where...
December 22nd 08 08:51 AM
by malycom Go to last post
4 1,007
I am trying to print labels in word 03 using Microsoft Address Boo by Dean down south
I cannot import or merge addresses from Microsoft Address Book to print labels in Word 2003. The result is unreadable.
December 21st 08 07:29 AM
by Graham Mayor Go to last post
1 768
Areas in Mailings field not highlighted by Celebratelife
I am using Word 2007 and working on creating a Mail Merge. None of my buttons on Write & Insert field in Mailings is highlighted and I need to use them. I have the Student Office installed and the trial Office Professional.
December 20th 08 08:17 AM
by Peter Jamieson Go to last post
1 831
Add Signature Tiff doc to 50 Word docs in same place by Janet A. Thompson
I have 50 word documents that I want to add the same signature to. Can this be done via Mail Merge? How? -- Janet A.
December 20th 08 04:16 AM
by Janet A. Thompson Go to last post
9 1,066
December 19th 08 06:35 PM
by jgale43 Go to last post
0 783
How do I format Mail Merge doc to pick up currency format from Exc by MamaSherry
Office 2007, Windows XP I have created a data base using Excel that contains several numbers that are formatted as currency. When I insert these fields into my Word document (letter), the currency formatting is not there. I'm very new to Word 2007 and can't figure out how to change this. All...
December 19th 08 04:46 PM
by MamaSherry Go to last post
2 1,827
How do I add recipients to a mailmerge label list? by Relztrah
This should be very simple. I created address labels using Word mailmerge and finished the merge, printed the labels, everything's OK. Now I want to add new recipients to my existing .mdb file and re-merge. I can open the original document and edit the existing recipients, but how do I actually...
December 19th 08 02:02 PM
by Graham Mayor Go to last post
7 1,831
mail merge cut off or truncating 255 word limit by jim
here is a good solution ms word 2003 (and probably works for other versions) for mail merges using an excel database (just an excel spreadsheet with your merge information) in microsoft word 2003, with any document open, go to tools, options click the general tab check "confirm conversion at...
December 19th 08 08:44 AM
by Peter Jamieson Go to last post
1 2,122
mail merge shows numbers for dates by jim
do you have a mailmerge where 12/14/2008 in the spreadsheet is turning into 39800 in your word document? first, make sure that all of your spreadsheet cells are in general format (format, cells, choose the general format). then, do NOT use just the date or other info that excel automatically...
December 19th 08 01:18 AM
by jim Go to last post
0 1,440
Mail merge problem with Word 2007 by goffer23
I am having a problem in getting a successful mail merge to print some labels usng Excel as a data source on a 3 column, 7 row sheet under Office 2007/Vista. When doing the merge, only the first row of labels gets completed. I have used the same Excel data under XP without problem. I have tried...
December 18th 08 08:41 PM
by GARYG Go to last post
9 1,460
Merging Word with Excel - using multiple rows within a letter by Merging Word with Excel
Hello, I'm trying to merge an excel document that has multiple rows for one area and I want to bring them into the one letter; i.e.: John Brown owns three cars. I want one letter for John, referencing the three cars. So the excell file would look like this: John Brown Camaro ...
December 18th 08 07:47 PM
by Merging Word with Excel[_2_] Go to last post
2 2,023
Post New Thread


Display Options
Showing threads 2021 to 2040 of 12024
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 03:05 PM.


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