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
If "Yes" then "Yes or round as percentage by John
I am trying to import data from Excel into a Word document via mail merge. All data in Excel is derived via a formula. One field Target is giving me trouble because is may be a percentage e.g.98.5%, a Yes/No. or Null. I have tried If Then and nothing seems to work to get the results I...
December 31st 08 09:08 PM
by John Go to last post
9 1,047
Problems with Mail merge with attachment by Emily
Hi, I am trying to send individual emails with individual attachments. I have followed the steps outlined in the article "Mail Merge to E-mail with Attachments" and am having a little trouble. I have created the directory, written the email I want to send, connected to data source (same...
December 30th 08 11:01 PM
by Peter Jamieson Go to last post
1 578
Extra space in "Name" field when merged by Mark
When I merge data into the 'name' field, the first line of the address block, there is an extra space in front of the name. The merge is coming from Excel and i have checked the formatting for the cells and it all appears fine..Thanks in advance
December 30th 08 05:46 PM
by Rich/rerat Go to last post
1 1,348
Mail Merge to E-mail with Attachments - NEED HELP Please.... by Abhishek Dadu
Hello, I have tried to follow the steps mentioned by you, in the link below, verbattim: http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm But, still I am quite UNABLE to send the "mail merge with attachment" successfully (tried both with 1 attachment & 2 attachment) . I am not getting...
December 30th 08 06:49 AM
by Graham Mayor Go to last post
7 1,446
word som e-mail editor by BN[_2_]
I Office 2003 var det muligt at bruge Word som e-mail editor. Der var en knap, så man fik til, copy osv. frem. I 2007 versionen kan man tilsyneladende kun sende et word dokument som vedhäftet fil. Og den der med copy/paste kan da bruges, men er jo ikke ligefrem noget fremskridt.
December 28th 08 05:16 PM
by Peter Jamieson Go to last post
1 572
Mail Merge to E-mail with Attachments - NEED HELP Please.... by Abhishek Dadu
Hello, I have tried to follow the steps mentioned by you, in the link below, verbattim: http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm But, still I am quite UNABLE to send the "mail merge with attachment" successfully (tried both with 1 attachment & 2 attachment) . I am not getting...
December 28th 08 12:55 PM
by Peter Jamieson Go to last post
1 723
last numbers of the record by dilbert firestorm
is there anyway to include the last # of a record on a label? I'm trying to get the label to show as 1/10, 2/10,, etc. from a table. -- Dilbert Firestorm Opus is my Hero!
December 27th 08 08:41 AM
by Graham Mayor Go to last post
8 890
When using Mail Merge to Email, how can you attach documents? by amanda
I am using Office 2003 and pretty well versed in Mail Merge to Outlook... but I can't figure or find a way to add attachments to the letter. I need to send the word document as HTML email with 2 other Word documents as attchments.
December 26th 08 08:28 PM
by Doug Robbins - Word MVP Go to last post
3 1,923
multple pages of labels won't print from mailmerge via excel data by quaffin1
I am trying to create mailing labels from Excel data. Defined name for list of addresses. This should be about 3 pages of labels. But after going thru the mail merge wizard it will only create a single page of labels. Everything works perfectly except it only pulls one page of source data from...
December 26th 08 08:24 PM
by Doug Robbins - Word MVP Go to last post
1 3,257
Mail merge outcome 0 by RazakMd
I'm trying to mail merge datas from my Excel.. Unfortunately some of my fields shows 0, instead of the actual text.. as oucome.. I have checked my datasource.. excel.. state general.
December 26th 08 06:14 AM
by Graham Mayor Go to last post
1 1,053
Avery label 5567 is not listed in my Micro Soft 2003. Solution? by Dave Pohl
I am trying to use my Avery Labels Hanging File Tabs 5567 TM to create file Tabs, however my Micro Soft Word 2003 Label Maker does not list 5567. What are solutions to this problem?
December 24th 08 07:59 AM
by Graham Mayor Go to last post
5 1,859
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,393
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 960
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 829
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,286
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,262
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 774
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 813
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 775
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 783
Post New Thread


Display Options
Showing threads 2001 to 2020 of 12017
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 09:56 AM.


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