LinkBack URL
About LinkBacks
Hi,
I have a spreadsheet with a UserForm created for sending emails. However, I can only send emails in plain text.
Does anyone know of a way how I can use Word 2007 as Email Editor in Excel 2007?
Hi,
I have a spreadsheet with a UserForm created for sending emails. However, I can only send emails in plain text.
Does anyone know of a way how I can use Word 2007 as Email Editor in Excel 2007?
Hello nobleprince,
I am not sure I follow your post. You state that you can only send emails in plain text. You then ask about about using Word as email editor. What are you trying to do? Do you want to change the email to Rich Text Format or HTML and resend it?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leigh,
I have a macro spreadsheet that I'm using to send emails from Excel 2007 due to lots of records.
Yes, I want the ability to be able to send emails in Rich Text Format and/or HTML?
See Ron de Bruin's Excel email code, you should find how to send as HTML
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi RoyUK,
I'm not able to locate the code for the HTML from the link you've sent. Could you please give more specific pointer(s)? Or a code?
Hello noblleprince,
Here is macro that will send a specified range in HTML format within the body of the email. If this isn't what you need, let me know and I will put something together for you that does what you need.
Please Login or Register to view this content.
Example of Using the MAcro
Please Login or Register to view this content.
Hi nobleprince
Assuming this issue is related to what we've been working on, the code Ive provided will send your emails in either HTML or Rich Text (at least it does in my tests). Check your settings in Outlook (New->Options->Format). Using the same procedures we've been working on, I've sent myself emails in HTML text.
See if this works for you.
John
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hi John,
Yes, I have re-attached the file here. I have enabled the HTML and RTF settings in Outlook 2007, but get the following error:
In the sample file I have put the signature under "sig". This is taken from the outlook/signatures RTF file. I have only put the signature into the excel "sig" as sample for you to try (i.e. create the same signature), as I prefer using the UserForm method.Please Login or Register to view this content.
Note that I am using an icon - twitter, in the signature which seems to be giving issues in terms of displaying in the signature, instead the above random characters appear.
Could you please check and let me know your thoughts?
Ash
Hi Ash
I've managed to resolve the issue somewhat. See the attached screen shot. Haven't figured out the translation yet. I've been through many iterations but haven't been successful. I've sent an email to the original author of the code (Ron de Bruin) to see if he can explain what the issue is.
I'll continue to play with it but unless I get some other input, I may not be able to resolve the image issue (the link beneath the image to the Internet works fine).
John
Hi Ash
This is close. I still see one issue. Play with it and let me know what issues you see. Send me a link to the Twitter Image you wish to use. I couldn't find it.
John
Hi Ash
I've "fixed" the issue I was concerned with and I found the Twitter Image you were using. I think the attached version handles the Icon issue. Please note that the Icon is stored on the Web. Enter your twitter account in Sheet2, Range D1.
This version pulls all "Signature" data from Sheet2 (which can be hidden). It no longer pulls the signature from Outlook. The previous version's signature link to Outlook would not handle the Image translation properly. I confirmed this with research on the Web.
Sheet2 has two named ranges...Signature and Twitter Account. Signature is dynamic such that it will expand or contract as you make changes.
Let me know of issues.
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks