+ Reply to Thread
Results 1 to 4 of 4

Exporting data to outlook?

  1. #1
    Registered User
    Join Date
    08-19-2005
    Posts
    1

    Exporting data to outlook?

    Hello all this is my first post im adequately familiar with Excel, but what i was wondering is i have a spreadsheet with a bunch of email addresses of clients and i want to set up a template that will be able to just insert these into an email in outlook, can i export them or soemthing from excel directly?

  2. #2
    Anne Troy
    Guest

    Re: Exporting data to outlook?

    Depends what you mean by "a template". Please provide more information.
    ************
    Anne Troy
    www.OfficeArticles.com

    "Stevehud99" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hello all this is my first post im adequately familiar with Excel, but
    > what i was wondering is i have a spreadsheet with a bunch of email
    > addresses of clients and i want to set up a template that will be able
    > to just insert these into an email in outlook, can i export them or
    > soemthing from excel directly?
    >
    >
    > --
    > Stevehud99
    > ------------------------------------------------------------------------
    > Stevehud99's Profile:
    > http://www.excelforum.com/member.php...o&userid=26453
    > View this thread: http://www.excelforum.com/showthread...hreadid=397196
    >




  3. #3
    Tushar Mehta
    Guest

    Re: Exporting data to outlook?

    Search Outlook's help for "import contact" (w/o the quotes). It will
    lead you to a MS website topic 'Import contacts from Excel to Outlook'
    (http://office.microsoft.com/en-us/as...964231033.aspx)

    While I haven't tried the process (for obvious reasons), I suspect the
    XL template will have to be a table form list with the 1st row
    containing heading names and the rest of the rows containing the
    information of 1 contact per row.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    >
    > Hello all this is my first post im adequately familiar with Excel, but
    > what i was wondering is i have a spreadsheet with a bunch of email
    > addresses of clients and i want to set up a template that will be able
    > to just insert these into an email in outlook, can i export them or
    > soemthing from excel directly?
    >
    >
    > --
    > Stevehud99
    > ------------------------------------------------------------------------
    > Stevehud99's Profile: http://www.excelforum.com/member.php...o&userid=26453
    > View this thread: http://www.excelforum.com/showthread...hreadid=397196
    >
    >


  4. #4
    Registered User
    Join Date
    08-11-2005
    Location
    Netherlands Waddinxveen
    Posts
    81
    If you reference the outlook object model in your VBA IDE (editor)
    tools->references

    you can create an instance of outlook and manipulate it's adress book if tha't what you want.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1