Group:  Microsoft Word » microsoft.public.word.mailmerge.fields

Threads Replies Last Post
168 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  
Envelope printing
Hello, I'm using word 2007 and when trying to add an address from my Microsoft Outlook 2007 address book to an envelope in Word 2007 it keeps coming up with the Microsoft Error every time and gives me the choice to send it or not then re-opens word after it has sent it. After viewing the error report it gives the code 0xc0000005 Can anybody help me resolve this issue? Cheers - Adam H...
4 12/11/2008 6:05:57 AM
Mail merge to custom envelope size 8x5
i created a mail merge from excel data to a custom word document that is 8"w x 5"h, the size of my envelope. Data came over fine. When I send to my printer (Epson Stylus R300 Series) and feed the envelope in, it puts a lead of 3.75" before it starts printing, throwing off where the text appears. How do I get rid of the 3.75" lead and just get it to print right away?...
2 12/11/2008 5:52:25 AM
How do I maintain a numeric format when importing data from a xls
How do I maintain a numeric format when importing data from a xls...
2 12/11/2008 3:18:00 AM
Merge Document Properties?
Is it possible to merge document properties? I am using Excel 2007 and Word 2007, and would like to be able to set the "Category" property of the merged word documents via the merge itself using a column in my Excel range. Thanks!...
2 12/11/2008 12:03:11 AM
Only part of data in Excel field is merged into Word
I am using Office 2007. I successfully inserted merged fields from Excel into my form in Word. All but one of the fields came out fine. There was one field I called "notes" (from Excel) that would consist of several lines of information but when it is brought to Word, only the first few lines are shown in my document. In the document it displays exactly 2 1/2 lines of information, then n...
3 12/10/2008 7:46:05 PM
Windows Contacts Mail Merge Address Labels - Multi Line Addresses
Dear All, I want to complete a mail merge in word to print out address labels. The addressing data has been entered via windows contacts on a vista pc. Following the prescribed method I have exported the contacts to a CSV file. Imported that to an Excel Sheet and completed the usual merge processes. The problem lies with addresses containing 2 or more lines with in the Windows Contac...
5 12/10/2008 5:20:00 PM
Mailmerge from Excel in Memo format
I am having a bit of a frustrating time doing what Office 2000 used to do so well. Creating a mail merge document from an Excel spreadsheet using an export from a memo field which contains the address of the recipient with carriage returns. What happens is I select mailing labels, go through the step by step wizard. For reasons best known to Microsoft, they now expect addresses to be lin...
6 12/10/2008 4:33:29 PM
make mailmerge leave blanks when fields are empty
Mailmerge kindly moves fields together when there are blanks (like in a short address). Does anyone know how to stop this so the balnks are retained? Also, does anyone know how to ensure that a field defined in Excel as text, but containing mainly numbers, is treated by Word as text. At the moment, it seems to treat this data as numeric, and represents any fields containing non-numeri...
2 12/10/2008 3:51:48 PM
word template in the body of outlook?????
Outlook and Word 2007. I posted this in the Outlook forum and Word general ?'s but thought someone here may know as well... I have a template that I created in MS Word and what I'm wondering is this...can I use this template in the body of my Outlook message? I do not want it to be an attachment. I want it to be displayed as the main body of the message. My clients may not rea...
2 12/10/2008 3:48:50 PM
How do I merge formula results in Word 2007?
When I am merging formatted dates (=date in another cell plus 14 days) the merged results are the numerical equivalents of the dates. How can I keep the actual formatted dates without saving the dates in the spreadsheet as values? Other typical merging errors include losing the number formatting (dollar signs, comma separator, etc.) ...
3 12/10/2008 9:25:56 AM
Mail Merge in Office Word 2007 - Labels
I need to use at least 4 lines for the address, sometimes more. For instance there may be Address 1, 2, 3 and sometimes I have a PO Box in which case there is no need for Address 1 and 2, etc. My label is big enough, but due to default line spacing in Word I cannot fit all the Address lines on the label without losing the city and state and zip. Also, how can I elminate Address 1 & 2 if...
5 12/10/2008 7:11:15 AM
Can two .mdb files in Word be merged?
I have created two separate mail merge address databases and I would like to know how to merge the data into one database. Can any one help? Thank you....
2 12/10/2008 7:05:25 AM
How Do You Limit Decimal Places In Mailmerge Value From Excel?
The value is formatted in excel but the formating is not applied in the word documents mailmerge value. There is no switch option I can see for limiting decimals in mailmerge numbers. Thankyou...
2 12/10/2008 7:01:54 AM
Merging to Labels - Controlling printing
I am printing labels using a 10 labels per sheet (A4) shipping label. I have a return address printed in a colour and a particular font (Arial 8pt) at the top left corner. Then the address is lower and indented. The last sheet of labels will usually have several that are not used for addresses but have the return address printed on them. How can I get these unused labels to be complete...
3 12/10/2008 7:00:39 AM
Problems Encountered with Mailmerge
I have never experienced this before, using Word 2003 and performing a mail merge to create labels from a Word table as the datasource, the first time I performed the merge it appeared to execute successfully but in reviewing the labels, 32 names did not merge. So, I performed the merge again using the same template and datasource. This time, 42 names did not merge (different from the f...
2 12/9/2008 9:02:26 PM
Problems with mail merge to labels
This is a problem I am having on two separate computers. Both of these computers have recently been upgraded to Vista Business. One was a clean install the other was an upgrade over XP. Both machines have Office Enterprise 2007 installed. I have many Excel lists of addresses that I use for Real Estate mailings. Since I upgraded when I do the mail merge wizard in Word everything work...
4 12/9/2008 7:08:37 PM
Mail Merge Data Source
I'm using Microsoft Office 2003. I have several different word documents located in different areas on my computer and I merge from several different Excel spreadsheets. Once I set up a mail merge from one particular spreadsheet, 9 out of 10 times I always want to use that same, particular spreadsheet for that particular Word doc. Usually, I don't have a problem opening the document. I...
3 12/9/2008 4:55:01 PM
Email mail merge - multiple emails in field
Hi I am trying to send out a mail merged email but some fail as some contacts have more than one email address in the email field. What should they be separated by to be able to send to both emails if possible? Thanks...
3 12/9/2008 12:11:38 PM
Mailmerge leaves out blanks at the start/end of mergefields
I have a mailmerge with 4 fields like this: «G1»«G2»«G3»«G4» My problem is that if a field end/starts with at blank it is left out -> missing blank between two words Here is a test merge where there should be a blank between G1-G2, G2-G3 and G3-G4: 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 ...
2 12/9/2008 12:01:51 PM
merge not allowing all data from excel
I am simply merging an excel worksheet to address labels. I have 1364 entries but when I select my database in only shows 649. What am I doing wrong? Thanks....
2 12/9/2008 3:58:52 AM
Directory merging across, not down
Hello, is it possible to do a directory merge where each column is a complete record from the data source, and each row is a field? This would effectively merge the data across the screen instead of down. For example: Each column is a product. Each row is an attribute of the product. Product 1 Product 2 Product 3 Shape Round Square Triangle Color Wh...
2 12/8/2008 7:51:49 PM
Merging Similar Records
I'm hoping someone can help. A coworker has a database listing people and the parcels of land they own. Most people only own one parcel, so the merge is easy. Other people own multiple parcels and thus have multiple records. For example: Jane Doe 990.11.00 Jeff Dean 870.24.6 John Smith 109.1.08 John Smith 203.12.7 John Smith 221.13.1 When we do a normal merge, it cre...
2 12/8/2008 7:41:27 PM
Mail Merge Not Picking All Up data
In using a template someone gave me, I noticed that not all the Excel data was being included in the Word merge. The Excel data's first column was the first names of employees and this column seemed to be a hyperlink to their RSVP Outlook message. (Apparently, in Outlook you can set it up so that responses come into an Excel database automatically.) I took the 3rd and 4th column name...
6 12/8/2008 7:40:24 PM
How do I get a Word mail merge to keep my access date format?
I am using Office 2007 (trying to use mail merge to merge Access data in Word so I can control formatting). Word changes the date format from yyyy-MM-dd to MM/dd/yyyy. A previous post (for office 2003) suggested using a switch, but when I do that, Word reports that the field does not exist in the source. My mergefields are encased in pointed brackets rather than braces....
2 12/8/2008 6:58:31 AM
Mail Merge
When I mail merge my Outlook contacts on to labels they look ok on screen and are in the box area for each address. When I print them some over lap onto two labels. Why is this as all the procedures are correct. ...
2 12/7/2008 7:25:03 PM
168 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  

Home | Search | Terms | Imprint
Newsgroups Reader