Exporting data to outlook?

  • Thread starter Thread starter Stevehud99
  • Start date Start date
S

Stevehud99

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?
 
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/assistance/HA010964231033.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
 
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.
 
Back
Top