Recent content by Daro346

  1. D

    Macro sending outlook template from Excel list

    thanks... now that I have it working, my follow on question. In my outlook template there are fields for Greeting, Meeting Date, Next Meeting Date and Time. Is it possible to take these fields from the excel spreadsheet and populate the fields in the template? (i.e. like a mail merge of sorts)
  2. D

    Macro sending outlook template from Excel list

    this is using Outlook. It sounds like there's no work around, correct?
  3. D

    Macro sending outlook template from Excel list

    Thanks.. I moved the "set myitem" after the "for each mycell". When the macro runs it creates 2 drafts for each line in excel... thoughts?
  4. D

    Macro sending outlook template from Excel list

    I have an excel macro that creates an email in outlook using a template. Col A is the email address; Col B is the subject. The macro works, except when it loops through the list, instead of creating a new email and saving it as a draft, it overwrites the email. Sub test_send() Dim...
  5. D

    send email from Excel using outlook template

    Thanks... I've made some progress.... The macro code is below. It's only creating the entry on the last line from the excel sheet. I decided to start with Excel and run a macro to create an outlook message based on a template. column 1 is the email address, column 2 is the email subject. any...
  6. D

    send email from Excel using outlook template

    Thanks! I'll give it a try
  7. D

    send email from Excel using outlook template

    I found the macro that takes fields from excel and sends an email. I would like to create an email from an outlook template, populate fields from excel and save it as a draft. Here's the outlook/VBA macro - I'd like to pull from excel the following columns: Email Address, Meeting Date, First...
Top