Unsolved

This post is more than 5 years old

5 Posts

29786

October 12th, 2004 13:00

Access mailing list with MS Word

I have a client that has a mailing list already put together in Access, but we want to take certain names from the mailing list and attach them to a X-mas letter that will be done in Word. Can I do this? Any suggestions?

5 Posts

October 12th, 2004 14:00

Not really. I will check that out. I just don't want to have to retype all the names and addresses again. There are hundreds. I want to be able to pick certain names from the mailing list in Access and attach them to a generic letter in Word. Thanks.

2 Intern

 • 

18.8K Posts

October 12th, 2004 14:00

Linda Oz,

See this.

2 Intern

 • 

2.5K Posts

October 12th, 2004 14:00

Not quite sure what you want to do with the list exactly, but have you looked at the Mail Merge function?

5 Posts

October 12th, 2004 15:00

I tried that but wasn't able to actually bring the name and address of a person in from the mailing list done in Access to my letter in MS word.

1.7K Posts

October 12th, 2004 19:00

Linda,

Try this task from Access. Open the database, then choose the table or query where your data is stored. Click Tools, Office Links, Merge it with Word. Then follow the wizard to find your letter and insert the necessary fields.

1.7K Posts

October 13th, 2004 15:00

You can change that to Shared mode one of two ways:

Tools, Options, Advanced tab. Check the Shared Default Open Mode

or

When you open the database, look for a drop down button on the Open button in the dialog box and choose Shared.

The first is the easiest, but you may have to change it back again if needed.

5 Posts

October 13th, 2004 15:00

I tried that but it came up as "Mail Merge Wizard cannot continue because database is in the exclusive mode". I went to help to try to see what that was all about, but could find nothing.

5 Posts

October 14th, 2004 12:00

You did it. Thank you so very much. It worked. This has saved me hours of work. Thank you.

0 events found

No Events found!

Top