Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MailMerge - Macro from Excel to Outlook

    Hi all,
    I am looking at whether there is any way of doing the following:

    Set up a system of automatically sending 130 separate emails out once a week, all with a standard text.
    The standard text for each of the emails needs to have two dates within the text changed every week.
    The standard text for each of the emails has to contain a number specific to each email, which will change every week.

    I currently have an excel file, with 130 tabs. Each tab contains the standard text; with cells containing the dates and numbers that need to change; and these are linked to an excel spreadsheet which is updated with the correct dates and numbers every week. The tabs also each contain an email address, and a macro then automatically sends out these tabs by email.

    I want to know if it is possible to replicate what the excel macro file does in outlook?

    Your help is much appreciated

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi skender

    Set up a system of automatically sending 130 separate emails out once a week, all with a standard text.
    ..In Outlook, you can create a Contact Group for your 130 recipients, and create and use an Outlook Template for your standard text

    The standard text for each of the emails needs to have two dates within the text changed every week.
    if the two dates are the same two dates for all recipients, then you can have Outlook prompt you for these dates and have the template text updated
    The standard text for each of the emails has to contain a number specific to each email, which will change every week.
    ..do you mean "number specific to each email recipient or is the number the same number for that particular week

    zeddy

  3. #3
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for your reply Zeddy,

    The number is specific to each email recipient, and changes every week

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi skender

    Are you unhappy with running the macro from Excel???

    Are you asking to 'convert' the macro 'entirely from Excel to Outlook??
    Are you asking for Outlook to 'run the macro' (and get the required info from an Excel file)??
    Not sure about what you are looking for exactly.

    zeddy

  5. #5
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am looking to run the macro from Outlook, but get the required info from an excel file

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    Sounds like a fish trying to swim upstream. You might want to post in the Outlook Forum

    http://windowssecrets.com/forums/for...rosoft-Outlook

  7. #7
    Star Lounger Graham Mayor's Avatar
    Join Date
    Mar 2016
    Location
    Cyprus
    Posts
    68
    Thanks
    0
    Thanked 24 Times in 24 Posts
    Quote Originally Posted by skender View Post
    I am looking to run the macro from Outlook, but get the required info from an excel file
    Would it be possible to post a sample worksheet or better still a copy of the workbook (change any sensitive information) so that we can see how it is laid out? (Go Advanced and attach it, or link to a web location).

    Are there any other sheets in the workbook that are unrelated to the task in hand?

    Do the 130 sheets all have the same standard text (differing only in the variable data associated with each recipient)? If so a worksheet with the variable information alone could be used as either a mail merge source or as a data source to create variable content messages in Outlook. It would be possible to loop through such a worksheet in Outlook and create the messages on the fly - much depends on what is in the 'standard texts'.
    Graham Mayor - Word MVP
    http://www.gmayor.com

Posting Permissions

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