Thanks Peter for answering, to get right to it I opened excel and in the first row (A) I put the last name (B) is empty (C) is the first name (D) the street address (E) empty (F) city (G) empty (H) state (I) Zip Archer
Help I am going crazy I am trying to merge a label list excel
3 posts
• Page 1 of 1
- MS SQL SERVER
- hp
- c++
- Windows XP
- Windows
- MS Office Access
- Microsoft OFFICE
- dreamweaver
- mac
Jump to:
- 1. Can OpenDataSource use *SQLStatement when the DataSource is a CSV?
I am trying to figure out how to use a *SQLStatement on a CSV file. I want to do something like this: SELECT * FROM T:\PRT\ELGEXC14.CSV WHERE EGEXCODE="14" What would my OpenDataSource look like? - 2. wrong record in mail merge
This is probably an easy problem, but I'm attempting to mail merge a single record from an access database, and the record that is merged is always different from the record i choose in the 'merge records from x to x' fields. Any ideas what could cause this? Does word re-sort the database when you create the data source? - 3. Dropping trailing zeros in word 2000 mail merge
I have a client doing a mail merge in Word 2000 using an Excel 2000 spreadsheet as her source. This is a mail merge letter and two of the fields she is pulling are a dollar amount and a date field. She had the dollar amount formatted as a number with 2 digits after the decimal. She has the date field formatted as date using the month spelled out as in November 18, 2003. When she does the merge, the trailing zeros on the dollar amount are cut off and it converts the date to 11/18/03. I tried changing the formatting in the excel doc to currency for the dollar amount but the same thing happened. I can only find reference on Microsoft's site to this happening with Access as the data source so the help won't help me here. Anyone have any ideas? Thanks, Carla carla.bradley@[delete this]lgeenergy.com - 4. 2 data sources in one merge file
I have an invoice set up. I want to merge the names and addresses from one excel work sheet and the total amount due from a different excel work sheet to the invoice. I am using MS Word 2002. Can any one help me? I am desperate!! - 5. Creating an Index from a merged field
I wanted to know if it's possible to create an index for a merged field from access. I'm creating a directory and need one field to be indexed in word. Is this even possible? Any help would be great. Thanks. Krista
Next
Re: Help I am going crazy I am trying to merge a label list excel
by QXJjaGVyLS0tLS0tLS0tLS0tPg » Sat, 16 Apr 2005 14:18:07 GMT
Re: Help I am going crazy I am trying to merge a label list excel
by Peter Jamieson » Sat, 16 Apr 2005 15:22:20 GMT
OK, the first row needs to have the column headings. I would provide headings even for the columns that are empty, e.g. Lastname Empty1 Firstname Street Empty2 City Empty3 State Zip then follow Graham's articles. Peter Jamieson
Re: Help I am going crazy I am trying to merge a label list excel
by QXJjaGVyLS0tLS0tLS0tLS0tPg » Sun, 17 Apr 2005 10:48:02 GMT
hanks Peter for the help I tried it thru Micro, Publisher and after I
picked, which data base to use, I opened my same excel file. And when it came
up to editing my original list I expanded the box and spread the coloum open
that contained the zip code and presto that was it , it allowed all items to
show and print again thanks for the help. I will set one up the way you said
and give it a try. A name for each coloum.
Archer
"Peter Jamieson" wrote:
picked, which data base to use, I opened my same excel file. And when it came
up to editing my original list I expanded the box and spread the coloum open
that contained the zip code and presto that was it , it allowed all items to
show and print again thanks for the help. I will set one up the way you said
and give it a try. A name for each coloum.
Archer
"Peter Jamieson" wrote:
Similar Threads:
1.Help I am going crazy I am trying to merge a label list excel
2.Help I am going crazy I am trying to merge a label list excel to w
I do all the things that help said to and it will not go in, nothing shows up on the labels I have a list set up in excel and I can not get it into word as mailing labels it is driving me crazy. I tried it as a worksheet and as a list. I open excel and enter it, as follows Frodo frank 2541 west St. Hobbit pa 19130 I saved it as both a work sheet and tried it as a list, as well at a different time. and tried both ways. I have 600 names and adresses on my full list. I need an exact step by step way to merge from excel 2003 into word 2003 labels avery label # 5160 thats a 30 label page. I have tried to do it the way help says to do it and the labels come up blank and it does not help. Please do not refer me to help pages, I need a step by step directions. As in save it as ------ data base and so on. any help will be tremendously appreciated. I tried all their help pages no good. Archer
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 77 guest