+ Reply to Thread
Results 1 to 4 of 4

Mail Merge to email - can I send to Drafts folder in Outlook to edit BEFORE sending?

  1. #1
    Registered User
    Join Date
    05-25-2016
    Location
    Hollywood, CA
    MS-Off Ver
    2016
    Posts
    79

    Mail Merge to email - can I send to Drafts folder in Outlook to edit BEFORE sending?

    I setup a mail merge to Outlook thinking I'd be able to edit the messages before they sending, as I need to copy different info (from a list in Excel) to each one. But once I click the last OK, they're gone - no chance to edit. Is there some way to send the merged emails to the drafts folder so I can edit each one, then send? (I thought I'd ask just in case there actually is a way around direct email send)...

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Mail Merge to email - can I send to Drafts folder in Outlook to edit BEFORE sending?

    Mailmerges only ever send their output direct to your outbox. If you can configure Outlook to work Offline, the messages should sit there until you send them. You should be able to drag them from there to your Drafts folder for editing prior to sending.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    05-25-2016
    Location
    Hollywood, CA
    MS-Off Ver
    2016
    Posts
    79

    Re: Mail Merge to email - can I send to Drafts folder in Outlook to edit BEFORE sending?

    Thanks, I hadn't considered working offline... now that I have 20 individual emails setup, is there a way to edit those for the next mailing (minor changes to each) as a group, or do I really have to edit each email separately?? I suppose I'm just trying to find the best way to edit a group of emails (not exactly an Outlook whiz)... (Because I have different data from Excel in each email, I thought it would be easier to make the same edits to the body of each email, rather than re-merging, then having to individually copy the Excel data to each)

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Mail Merge to email - can I send to Drafts folder in Outlook to edit BEFORE sending?

    You'll have to edit each output email individually. Perhaps you should consider modifying the mailmerge main document to tailor each email to say what you want instead of trying to edit them after the event.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel email macro for outlook sending hyperlink, but need it to send as attachment
    By L_Misty in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2017, 03:40 PM
  2. looking help to send all drafts folder mail ...
    By ks1102 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2017, 06:09 AM
  3. [SOLVED] Split mail merge letters and send email
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-03-2015, 11:21 AM
  4. Mail Merge and Send Fax via Email
    By Gos-C in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2015, 03:31 PM
  5. [SOLVED] attach file from folder on c:\ to outlook mail and send
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-24-2013, 11:33 AM
  6. [SOLVED] Need Excell Macro to send out all the emails from Outlook Drafts folder
    By anto_01 in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 12-16-2012, 11:29 PM
  7. Send drafts in outlook with excel
    By MysticGenius in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2012, 12:16 AM

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