locked
Need help editing a large Word Doc for email addresses! RRS feed

  • Question

  • I have a 2700 page file that contains names, addresses, and email addresses and I want to extract the names with the correct email addresses and export that to Excel.  A sample of the file is below:

    John Doe 1     123 Any Street

                         Any Town, Any State 11111

                         JohnDoe1@Domain.com

    John Doe 2    456 Any Street

                        Any Town, Any State 22222

                        JohnDoe2@Domain.com

    John Doe 3    789 Any Street

                        Any Town, Any State 33333

                        JohnDoe3@Domain.com

    I want it to look like this outputted into Excel:

    John Doe 1     JohnDoe1@Domain.com

    John Doe 2     JohnDoe2@Domain.com

    John Doe 3     JohnDoe3@Domain.com

    If I can only get just the email addresses in a column form, that would work just fine.  Thanks for the help onthis.

    Michael

    Friday, April 15, 2011 6:12 PM

Answers

  • 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
     -- Hope this helps.

    Doug Robbins - Word MVP,
    dkr[atsymbol]mvps[dot]org
    Posted via the Community Bridge

    "DocMHale" wrote in message news:7496fb38-ac61-4397-9125-688832fab2d8@communitybridge.codeplex.com...

    I have a 2700 page file that contains names, addresses, and email addresses and I want to extract the names with the correct email addresses and export that to Excel.  A sample of the file is below:

    John Doe 1     123 Any Street

                         Any Town, Any State 11111

                        JohnDoe1@Domain.com <mailto:JohnDoe1@Domain.com>

    John Doe 2    456 Any Street

                        Any Town, Any State 22222

                       JohnDoe2@Domain.com <mailto:JohnDoe2@Domain.com>

    John Doe 3    789 Any Street

                        Any Town, Any State 33333

                       JohnDoe3@Domain.com <mailto:JohnDoe3@Domain.com>

    I want it to look like this outputted into Excel:

    John Doe 1     JohnDoe1@Domain.com <mailto:JohnDoe1@Domain.com>

    John Doe 2     JohnDoe2@Domain.com <mailto:JohnDoe2@Domain.com>

    John Doe 3     JohnDoe3@Domain.com <mailto:JohnDoe3@Domain.com>

    If I can only get just the email addresses in a column form, that would work just fine.  Thanks for the help onthis.

    Michael


    Doug Robbins - Word MVP dkr[atsymbol]mvps[dot]org
    • Marked as answer by Sally Tang Thursday, April 21, 2011 6:19 AM
    Friday, April 15, 2011 8:48 PM