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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Converting Acess data to use to print names and addresses on envel
I want to be able to convert my names and addresses in Access to Word so I
can print, let's say, my Christmas cards. Can this conversion be done? The names will have to be repositioned so they read first name first, last name last. Can someone help me??? |
#2
|
|||
|
|||
How are the fields currently stored in Access? Are First Name, Last Name two
different fields, or is there just one Name field. Also Did you know you can do a mailmerge type action within Access utilizing the Reports and Query features? I'm sure there's a way to mail merge Word using Access data, but if worse comes to worst, just export your table to Excel, and do your conventional mail merge. Hope this helps. "lindabelll" wrote: I want to be able to convert my names and addresses in Access to Word so I can print, let's say, my Christmas cards. Can this conversion be done? The names will have to be repositioned so they read first name first, last name last. Can someone help me??? |
#3
|
|||
|
|||
Thanks Micah. There are two fields, last name, and first name. When
converting them they would have to be reversed in word to print properly on the envelope. "Micah Chaney" wrote: How are the fields currently stored in Access? Are First Name, Last Name two different fields, or is there just one Name field. Also Did you know you can do a mailmerge type action within Access utilizing the Reports and Query features? I'm sure there's a way to mail merge Word using Access data, but if worse comes to worst, just export your table to Excel, and do your conventional mail merge. Hope this helps. "lindabelll" wrote: I want to be able to convert my names and addresses in Access to Word so I can print, let's say, my Christmas cards. Can this conversion be done? The names will have to be repositioned so they read first name first, last name last. Can someone help me??? |
#4
|
|||
|
|||
This isn't really an Access question. But I can help you anyway. Do you
have your labels or whatever already created in Word? If so good. If not do that first. Second, you'll want to do Mail Merge. Depending on what version of Office you're using (2000, 2003, etc) you can choose where your "source data" or "recipients" come from. When you get to this step, instead of choosing Outlook or Excel, you'd browse and find your Access database. Choose your table, follow the prompts and you should be able to choose only the fields you want to display and what order you want to display them. Let me know if this helps. "lindabelll" wrote: Thanks Micah. There are two fields, last name, and first name. When converting them they would have to be reversed in word to print properly on the envelope. "Micah Chaney" wrote: How are the fields currently stored in Access? Are First Name, Last Name two different fields, or is there just one Name field. Also Did you know you can do a mailmerge type action within Access utilizing the Reports and Query features? I'm sure there's a way to mail merge Word using Access data, but if worse comes to worst, just export your table to Excel, and do your conventional mail merge. Hope this helps. "lindabelll" wrote: I want to be able to convert my names and addresses in Access to Word so I can print, let's say, my Christmas cards. Can this conversion be done? The names will have to be repositioned so they read first name first, last name last. Can someone help me??? |
#5
|
|||
|
|||
OMG....thanks....that's just what I needed...I've been going nuts trying to
do the conversion thru Access instead of Word.....Thanks again. "Micah Chaney" wrote: This isn't really an Access question. But I can help you anyway. Do you have your labels or whatever already created in Word? If so good. If not do that first. Second, you'll want to do Mail Merge. Depending on what version of Office you're using (2000, 2003, etc) you can choose where your "source data" or "recipients" come from. When you get to this step, instead of choosing Outlook or Excel, you'd browse and find your Access database. Choose your table, follow the prompts and you should be able to choose only the fields you want to display and what order you want to display them. Let me know if this helps. "lindabelll" wrote: Thanks Micah. There are two fields, last name, and first name. When converting them they would have to be reversed in word to print properly on the envelope. "Micah Chaney" wrote: How are the fields currently stored in Access? Are First Name, Last Name two different fields, or is there just one Name field. Also Did you know you can do a mailmerge type action within Access utilizing the Reports and Query features? I'm sure there's a way to mail merge Word using Access data, but if worse comes to worst, just export your table to Excel, and do your conventional mail merge. Hope this helps. "lindabelll" wrote: I want to be able to convert my names and addresses in Access to Word so I can print, let's say, my Christmas cards. Can this conversion be done? The names will have to be repositioned so they read first name first, last name last. Can someone help me??? |
#6
|
|||
|
|||
I know this is an old topic, but my question is: why do I have to use an
Access table? I want to use an Access query. In the past with MS 2000, we mail-merged labels with queries regularly. Now I have MS XP and all that shows up are the tables..........? I can't use a query anymore to just create labels for a specific group for which I already have a query? "Micah Chaney" wrote: This isn't really an Access question. But I can help you anyway. Do you have your labels or whatever already created in Word? If so good. If not do that first. Second, you'll want to do Mail Merge. Depending on what version of Office you're using (2000, 2003, etc) you can choose where your "source data" or "recipients" come from. When you get to this step, instead of choosing Outlook or Excel, you'd browse and find your Access database. Choose your table, follow the prompts and you should be able to choose only the fields you want to display and what order you want to display them. Let me know if this helps. "lindabelll" wrote: Thanks Micah. There are two fields, last name, and first name. When converting them they would have to be reversed in word to print properly on the envelope. "Micah Chaney" wrote: How are the fields currently stored in Access? Are First Name, Last Name two different fields, or is there just one Name field. Also Did you know you can do a mailmerge type action within Access utilizing the Reports and Query features? I'm sure there's a way to mail merge Word using Access data, but if worse comes to worst, just export your table to Excel, and do your conventional mail merge. Hope this helps. "lindabelll" wrote: I want to be able to convert my names and addresses in Access to Word so I can print, let's say, my Christmas cards. Can this conversion be done? The names will have to be repositioned so they read first name first, last name last. Can someone help me??? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I print a list of names and addresses ONLY from my contact. | Lynnbo | New Users | 1 | January 24th, 2005 06:38 PM |
Can I convert a list of "smart tag" names and addresses to a data. | Sue | General Discussion | 0 | November 28th, 2004 09:32 PM |
Identifying Dublicate names and addresses in Exel data base and r. | Willgh | General Discussion | 1 | August 18th, 2004 11:21 AM |
Changing contact names to email addresses | dan | Contacts | 3 | May 30th, 2004 11:36 AM |