+ Reply to Thread
Results 1 to 2 of 2

Word Mail Merge with differnt attachment like excel file, ppt file, pdf etc.

  1. #1
    Registered User
    Join Date
    07-06-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    71

    Word Mail Merge with differnt attachment like excel file, ppt file, pdf etc.

    Dear All,

    I need one help.

    I use mail merge to forward smilar type of information to group of people.

    To make this work, I use word mail merge with email addresses present in an excel file which is working fine.

    Further, many times, I also need to forward an attachment which is like .doc, .xls or .xlsx or .pdf files.

    Is there any way by which I can attach these files by using word mail merge (as word provides way to make my document well formatted).

    Would appreciate, if experts guide me in this.

    Regards,

    Kundanlal

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,176

    Re: Word Mail Merge with differnt attachment like excel file, ppt file, pdf etc.

    This is my "off the shelf" from my workbench mailer in Excel. It is up to you to write code to "feed" the arguments such as a list of email addresses and maybe even customizations like adding a person's name or whatever.

    This subroutine takes a number of arguments:
    • Who to mail to
    • Subject
    • Message Body
    • CC (optional)
    • BCC (optional)
    • Attachment (full path name)
    • Send flag

    The Send flag is false by default which means that the mail message will be composed, but not sent. You have a chance to edit it. True means the mail goes out automatically without intervention.

    Multiple attachments can be sent. Use the full path names and separate them by the semicolon (. These attachments can be any kid of file.

    Please Login or Register  to view this content.
    Last edited by dflak; 11-25-2021 at 07:42 PM.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Replies: 6
    Last Post: 09-30-2019, 01:14 PM
  2. VBA to open a word document that is already linked in an Excel file for mail merge?
    By mshiddensecret in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2015, 07:08 PM
  3. Open Word mail merge file from excel button
    By jtemp57 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2014, 08:18 PM
  4. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  5. [SOLVED] RUN a mail merge (Word file) from a USERFORM in EXCEL
    By alopecito in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 09-18-2012, 09:41 PM
  6. Mail Merge into Word doc from Excel file not working?
    By danny2000 in forum Word Formatting & General
    Replies: 3
    Last Post: 05-30-2010, 05:19 PM
  7. Word Mail Merge with Excel as data file
    By HT in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-13-2005, 07:05 PM

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