Closed Thread
Results 1 to 3 of 3

Can I put an Excel Userform or its contents into an email produced in Outlook

Hybrid View

Osprey2 Can I put an Excel Userform... 08-14-2021, 03:47 PM
Osprey2 Re: Can I put an Excel... 08-14-2021, 03:49 PM
alansidman Re: Can I put an Excel... 08-14-2021, 03:56 PM
  1. #1
    Forum Contributor
    Join Date
    02-01-2021
    Location
    Manchester
    MS-Off Ver
    365
    Posts
    222

    Can I put an Excel Userform or its contents into an email produced in Outlook

    At the moment I create quotations as a UserForm filled with data in an excel workbook which I attach to an email. This is rather a clumsy method which I hope to improve. I would like to be able to copy the UserForm straight into the body of the email.
    I have discovered that the UserForm is invisible to most of the file types presented in the SaveAs routine of Excel. I had hoped that a PDF file would work. I can save the data that was in the UserForm in the PDF but, it seems, none of any extra images that are present. (I had tried replacing the form with a grid of inserted lines). They were not saved. I feel that there might well be a way to achieve my aim but have reached my limit. Can any one help please
    John

  2. #2
    Forum Contributor
    Join Date
    02-01-2021
    Location
    Manchester
    MS-Off Ver
    365
    Posts
    222

    Re: Can I put an Excel Userform or its contents into an email produced in Outlook

    I should have included in my opening post that as much as possible of the process should be achieved by code.
    John

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2506 Win 11
    Posts
    24,764

    Re: Can I put an Excel Userform or its contents into an email produced in Outlook

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread:
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy an Outlook Email Contents and Paste in a New Email Keeping Format
    By lougs7 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-14-2020, 08:53 PM
  2. [SOLVED] Macro to create an outlook email with contents of various cells?
    By russwongg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2019, 02:24 AM
  3. Copy Cell Contents into outlook email
    By ahalliwell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2018, 01:43 PM
  4. [SOLVED] Email Font Size Issue with emails produced from Excel VBA
    By Tooley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2017, 11:13 AM
  5. [SOLVED] Send Excel Userform Data to Outlook Email
    By kaemerso in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2017, 03:11 PM
  6. [SOLVED] Transfer Excel cell contents to Outlook Email
    By kchm2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2017, 10:43 AM
  7. Replies: 1
    Last Post: 11-01-2012, 10:00 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