Can I create a database from labels that are already created?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pb - 15 Apr 2008 20:54 GMT

Labels were typed up by a previous empolyee who did not use mail merge. I
would like to use that information to create a mail merge capability.
However, when I try to set up a database with the existing labels, the format
is off becuase it does not go in the correct order-- eg. first name, last
name, street. It takes the subsequent names and fills them in the address
info. There are hundreds of names on the list, so re-typing all the info
would be cumbersome. Thanks you all for any suggestions.

Reply to this Message

Doug Robbins - Word MVP - 15 Apr 2008 23:52 GMT

See "Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's
website at:

http://www.gmayor.com/convert_labels_into_mail_merge.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Labels were typed up by a previous empolyee who did not use mail merge. I
> would like to use that information to create a mail merge capability.
[quoted text clipped - 5 lines]
> info. There are hundreds of names on the list, so re-typing all the info
> would be cumbersome. Thanks you all for any suggestions.

Reply to this Message

pb - 16 Apr 2008 19:14 GMT

Doug,
I have Word 2003. So when I went to the replace section, and put in ^13(2),
it did no find anything. Does Word 2003 have a differenct code ofr the
paragraph marks. The double paragraph marks did show up when I converted the
table to text, but I got stuck at the "replace" step.
pb

> See "Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's
> website at:
[quoted text clipped - 10 lines]
> > info. There are hundreds of names on the list, so re-typing all the info
> > would be cumbersome. Thanks you all for any suggestions.

Reply to this Message

Doug Robbins - Word MVP - 16 Apr 2008 20:38 GMT

It should be ^13{2} not ^13(2) - That is "curly brackets", not parentheses

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Doug,
> I have Word 2003. So when I went to the replace section, and put in
[quoted text clipped - 23 lines]
>> > info
>> > would be cumbersome. Thanks you all for any suggestions.

Reply to this Message