Over 1 million tech questions and answers.

Macro to email centain range in body of email as well as the whole workbook

Q: Macro to email centain range in body of email as well as the whole workbook

Hello, I'm just joined and am trying to create a macro that will automatically email an entire workbook to a list of individuals. I also want the macro to copy and paste a range of cells within a specific sheet in the workbook and paste it into the body of the email. I am able to email the workbook but can't figure out the second part. Any help would be appreciated.

I am using Excell 2007 and LotusNotes 8.5.1

RELEVANCY SCORE 200
Preferred Solution: Macro to email centain range in body of email as well as the whole workbook

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Macro to email centain range in body of email as well as the whole workbook

Hi, welcome to the forum.
There are several posts where I added some simple tips and tricks.
Do you have the macro you use now to mail the whole workbook?
If I see how you have done this then maybe it's a cinch to add the extra info
You may also post a workbook with fictious data if you wish

Read other 1 answers
RELEVANCY SCORE 100.4

Hi,

I am building an Excel file and I need code for a macro that will allow me to automatically email this file.

At the moment I have code that will allow me to email the active worksheet, (see below) but I need it to email the complete workbook (all 3 worksheets).

Sub eMailActiveWorksheet()

Dim OL As Object
Dim EmailItem As Object
Dim Wb As Workbook
Dim FileName As String
Dim y As Long
Dim TempChar As String
Dim SaveName As String

Application.ScreenUpdating = False
Set OL = CreateObject("Outlook.Application")
Set EmailItem = OL.CreateItem(olMailItem)
FileName = ActiveSheet.name & " - " & ActiveWorkbook.name
For y = 1 To Len(FileName)
TempChar = Mid(FileName, y, 1)
Select Case TempChar
Case Is = "/", "\", "*", "?", """", "<", ">", "|", ":"
Case Else
SaveName = SaveName & TempChar
End Select
Next y
ActiveSheet.Copy
Set Wb = ActiveWorkbook
Wb.SaveAs SaveName
'Wb.ChangeFileAccess xlReadOnly
With EmailItem
.Subject = Range("C24").Text & Range("F24").Text & "; ICT SERVICES FAULT REPORT"
.Body = "FAULT REPORT NUMBER" & vbCrLf & _
"Line 2" & vbCrLf & _
"Line 3"
'.To = "to be filled in later"
.Importance = olImportanceNormal 'Or olImprotanceHigh Or olImprotanceLow
.Attachments.Add Wb.FullName
.Send
End With
Kill Wb.FullName
Wb.Close Fal... Read more

A:Email Complete Workbook Macro Needed

Am i missig something ? - can you not just use the built in Menu item - Send To ?
 

Read other 2 answers
RELEVANCY SCORE 98

Dear Friends,

I have prepared a macro which sends email to recipients whenever a project is due or will be due. For which i have set criteria of +3 i.e. if project is due on 19-Nov-16 then excel will show alert 3 days before 19 nov.
In macro i have put plain text in body due to which there is no identification to whom it has been sent or to whom it has been addressed.

What is required, which i am unable to get it in this forum.

Expected result: i want mail body to be like this whenever macro is run:
Currently i am unable to put code for below example

Dear <Name of the person handling project>
Your Project <Name> is due on < uat due date> and needs attention.
Kindly ignore if already done and update in sheet.
Data to be captured by macro:
Project name you will get in column D i.e. description
Person handling project in column P
uat due date mentioned in column I

Please help.. thanks in advance.
Regards,
Gaurang M
 

A:Email to recipient with details in Mail Body using macro

Hi,
Please try the attached, see how it works for you in, note that the email will be generated as soon as you open the workbook.

Also note:

1) I am using column N to look for "Send Reminder" in order to generate the emails, this is because you have done the hard work will the formula so don't really need to dynamically change and check the dates with code.

2) If you want the emails to be sent automatically without being displayed, you can change .display with .send

Let us know how this works for you.

DataBase
 

Read other 3 answers
RELEVANCY SCORE 92.8

Hello,

My first post, sorry to be a leech right off!

I'm trying to automate some of my day to day emails. I'd like to get a macro set up that will send an email from Excel and paste the range I select in to the body of the email. Would be great if it would send to a list of addresses listed on the page as well.

Using the attached example, I'd like the macro to take whatever range I highlight on the table, copy it to the body of an email and send it to the group of emails listed on the right side.

I'm learning excel, this would help me a lot! I'll be editing this to fit a variety of other tasks. I hope it can be flexible. Thanks in advance.

Chris
 

A:Macro: Email Range/Selection to group from Excel

http://www.rondebruin.nl/mail/folder3/mail4.htm

I have done the looping attached.
 

Read other 2 answers
RELEVANCY SCORE 88

Sorry about posting in this forum, I see no suitable forum and therefore I may as well post in the busiest.
I am looking for an email provider which allows both filtering by keywords in the message body and also has email forwarding.
This is because I am trying to filter out spam emails from one email address however the email provider (hotmail) cannot filter by message body.

Therefore I will need to forward emails to this new email address (by another provider which I need suggestions of) and have these emails filtered by message body and forwarded back to the original email address. I know that all email incoming from this new email address will be filtered emails and hence can set a rule to redirect them to another folder.

I have tried yandex which is the only I have found which claims to offer these facilities but no emails appear to be appearing in the inbox.

Read other answers
RELEVANCY SCORE 88

I have an email I get on a regular basis that I can see who it's from and the subject line but the body of the email is blank. I have problems with it in WLM but I can view it just fine in web mail and from my iPhone. Not sure if it's an issue on the end of the person who's sending it or an issue with WLM but since I can view it completely in web mail and on my iPhone I would think it's something with WLM. Thanks for any help anyone can give.

A:Body of email not showing in one particular email in Windows Live Mail

Hi, I finally was able to talk with someone from the place that was sending the email in question I was having issues with. They found out their emails are not compatible with WLM but are working on a resolution. I'm not sure what kind of email service they're using but it's not like WLM is some obscure mail client. Anyway, I'm marking this as solved even though I've received a few emails from them since and still having the issue of nothing in the body of the message. Now that they've figured out what the issue is I hope they fix it soon.

Read other 1 answers
RELEVANCY SCORE 82.4

Problem: when an email is replied to in Plain text - an email address is slipped in to the email's body: "<mailto:[email protected]>" It's not being done by the person replying and it's only happening to 1 user.

what I've done so far:
a. I've already checked the user's signature and I dont see "mailto:" anywhere
b. checked the user's AD account

what else can slip this line in??
 

A:Outlook 2003 - adding "<mailto:[email protected]>" inside body of email

Read other 9 answers
RELEVANCY SCORE 81.2

I have a word document that includes a form the user must fill in. I want to create a button that will do all of the following:
1. Update all fields
2. Attach the updated word document to an email
3. Enter an address I have stored in the macro into the To field of the email.

I have one module which does the first part:
Sub CommandButton1_Click()
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
oStory.Fields.Update
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
oStory.Fields.Update
Wend
End If
Next oStory
Set oStory = Nothing
End Sub

I found that if I add this to the before End Sub it attaches the updated Word document to an email:
Application.Options.SendMailAttach = True 'Or False
ActiveDocument.SendMail

However, I can't figure out how have it put a specific address into the To field of the document.

So I tried another tact. I have the email address as a hyperlink in the document, and set a bookmark at the hyperlink. Then I created a module that will go to the bookmark and open the hyperlink. However, this will not add the document as an attachment:

Sub Open_Hyperlink()
Selection.GoTo What:=wdGoToBookmark, Name:="hyperlink"
With ActiveDocument.Bookmarks
.DefaultSorting = wdSortByName
.ShowHidden = False
End With

Selection.Range.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End Sub

So then I found this bit of coding on the web, and tried imp... Read more

A:Word Macro to attach doc to email, then send address email

I found a solution, but I think it is a bit bulky. It seems to work but I'd love to know if there is a simpler solution:
Sub CommandButton1_Click()
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
oStory.Fields.Update
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
oStory.Fields.Update
Wend
End If
Next oStory
Set oStory = Nothing

ActiveDocument.Save

MsgBox "Thank you. Your order has been sent", vbOKOnly, "Thank you. Your order has been sent"
Dim bStarted As Boolean
Dim oOutlookApp As Outlook.Application
Dim oItem As Outlook.MailItem
On Error Resume Next
If Len(ActiveDocument.Path) = 0 Then 'Document has not been saved
ActiveDocument.Save 'so save it
End If
Set oOutlookApp = GetObject(, "Outlook.Application")
If Err <> 0 Then 'Outlook isn't running
Set oOutlookApp = CreateObject("Outlook.Application")
bStarted = True
End If

Set oItem = oOutlookApp.CreateItem(olMailItem)
With oItem
.To = "[email protected]"
.Subject = "Promo Order" '
.Body = "Thank you for your order"
.Attachments.Add Source:=ActiveDocument.FullName, Type:=olByValue
.Send
'**********************************

End With
If bStarted Then 'If the macro started Outlook, stop it again.
oOutlookApp.Quit
End If
Set oItem = Nothing
Set oOutlookApp = Nothing
End Sub
 

Read other 1 answers
RELEVANCY SCORE 78.8

Dear Guyz

I have a macro helped and developed by a respected admin of this group

it has following statement

If Cells(lRow, "N").Value >= 5 And Len(Trim(Cells(lRow, "P").Value)) > 0 Then ' check if the months passed are >= 5 (same as the red conditional formatting)
If Len(Trim(Cells(lRow, "O").Value)) = 0 Or (IsDate(Cells(lRow, "O").Value) = True And Month(Cells(lRow, "O").Value) <> Month(Date)) Then
toList = Cells(lRow, "P") 'gets the recipient's email address Column O

I want to add another line from another macro

If cell.Value Like "?*@?*.?*" And _
LCase(Cells(cell.Row, "C").Value) = "yes" Then

which makes sure that only @ emails are there and also ensures to which person it has to email and which it has avoid.

Can anybody help me to sort out this especially @Keebellah
 

A:Yes for Email No for no Email Condition in an if Statement of macro

Read other 7 answers
RELEVANCY SCORE 76.8

Hello Everyone

I am having some difficulties finding a solution to my problem. I am hoping someone can help or lead me to the right direction.

I have a workbook called Data.xlsm, below is a sample:

ID, Name, commission
1 john 1000
2 eric 2000
3 ryan 3000

Now I have another excel file called Temp.xls which looks pretty much the same as Data.xlsm.

ID, Name, Commission
1 john 200
2 eric 300

I need a macro that will read the Temp.xls and grab the commissions and bring them to Data.xlsm. The commissions need to be summed based on ID.

The final Result on Data.xlsm should be as follows:
1 john 1200
2 eric 2300
3 ryan 3000

Any help would be greatly appreciated.

Thank you
 

A:Solved: Excel Macro - Upload Workbook value from Another Workbook based on ID

Just a quick and dirty solution

Make sure you place this in the same folder as your Temp.xlsm file and press the button

It will open Temp
update the data, if a new Id is in Temp it will add the data and set the commission values in Temp to 0 to avoid running it twice.

I hope the code explains itsefl.

Think of a macro of a step by step instrcution as you would say it out loud.
 

Read other 3 answers
RELEVANCY SCORE 75.2

I reveived an email that has a inspiring message, images and music in it. This all came in the body of the message instead of as an attachement. I saved it as and .eml file but want to post it and can't find the url. Also it has a bunch of addresses I would rather not pass on. Any suggestions?
 

A:Same Body Of Email

Read other 9 answers
RELEVANCY SCORE 74.4

Hi There
I have searched the internet to see if I could find a macro that opens a workbook and runs a macro. In other words, I have workbook 1 (master workbook) and workbooks 2,3,4 ...1000. So far I found a macro that opens workbooks 2, 3, ...1000 by running a macro from workbook 1. Now I have a macro in workbooks 2,3,....1000. What I want is to run the workbooks 2,3,...1000 macro from workbook 1. I can do it if I call the workbook name. But I don't want to do that, since I have over 1000 workbooks. Below is the code.

Sub WWNumbers()

Dim fso As Object 'FileSystemObject
Dim fldStart As Object 'Folder
Dim fld As Object 'Folder
Dim fl As Object 'File
Dim Mask As String
Dim thisFolder As String
Dim fullFilename As String

Set fso = CreateObject("scripting.FileSystemObject") ' late binding
Set fldStart = fso.GetFolder("C:\Users\Mario\Documents\Folder1 Name\Folder2 Name")
Mask = ActiveCell.Value
thisFolder = fldStart & IIf(Right(fldStart, 1) = "\", "", "\")
Debug.Print thisFolder, Mask
If Not IsError(Dir(thisFolder, vbReadOnly)) Then
If Dir(thisFolder & Mask, vbReadOnly) <> "" Then
Workbooks.Open Filename:=thisFolder & Mask
Else
fullFilename = ListFolders(fldStart, Mask)
If Len(Trim(fullFilename)) > 0 Then
Workbooks.Open Filename:=fullFilename ' workbook2 opens here just fine
Application.Run "UnhideSheets" ' I get an error here
End If

End If

End If
... Read more

Read other answers
RELEVANCY SCORE 74.4

I have vista home basic.......I think it is version 6. Been real good but recently mail is coming in as normal but the body of the message is blank. How can I fix

A:Body of email is blank

What email client are you using?
Outlook or Windows Live Mail? Which version?

Read other 3 answers
RELEVANCY SCORE 74.4

I have been using Incredimail XE Premuim for about 2 years and this morning when I opened up Incredimal, the body of email just slid down to the bottom of the screen leaving me with just the sender and subject line(See Screenshot}. I have tried dragging it back up but all that does is drag the task bar up. Tried a full restart but the same thing happened. I realise that Incredimail has its own thread but I couldnt find a new thread starter..
 

Read other answers
RELEVANCY SCORE 74.4

yahoo mail compose click and format your message using these tools& type your message here body of email not display

Read other answers
RELEVANCY SCORE 74.4

Sometimes I get emails with blank bxes where images are supposed to be.....right clik 'show picture' doesnt work.
...any ideas?? How can I view these images?
 

A:Images in email body

Hello,

Are you able to drag the picture icon to your desktop and then right click and choose "open with" and then choose your photo program or your browser? I expect someone else will have a better reply.

Hope you get the problem sorted soon.

Bye,
Penny
 

Read other 3 answers
RELEVANCY SCORE 74.4

Hi,

Hopefully this is just a missed setting, I dont really want to delete & reinstall this user.

When I try to download emails under 1 of my accounts set up in Outlook Express, the header downloads (from/to/subject), but there is no text in the body of the emails, & no attatchments are shown or downloaded.

All other accounts work fine.

Any thoughts on how to fix this????

Rob.
 

Read other answers
RELEVANCY SCORE 74.4

Hello

I have just created a new email signature in Outlook 2003 and now a 1.30CM margin has been created from the left hand side of the page, thus everything i type is offset by 1.30CM from the original margin.

Does anyone know what setting I will have to change so that i can remove this margin?

Any help would be appreciated
 

Read other answers
RELEVANCY SCORE 73.6

i just got an email. there is no reply to address, unspecified sender, no type of info at all. how can that be?

here's the message source fro the properties box:
X-Message-Info: P3NBY493gE6hBQzp9DVcGTWFfTwZMuDr
Received: from BSN-77-92-81.dsl.siol.net ([193.77.92.81]) by mc8-f18.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713);
Fri, 28 Nov 2003 16:08:37 -0800
Received: from 236.98.20.135

does that help?
i didn't know you could send messages without your email address somewhere on it...
 

A:email with no sender, no subject, no body- no nothing

Read other 6 answers
RELEVANCY SCORE 73.6

Has anyone ever had this problem? Several emails sent to me recently were filled throughout with computer code such as the following:

<[email protected]>
MIME-Version: 1.0
--_e17db661-cbd5-4aa0-a76f-0931c2a5f79c_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


=20

Subject: FW: And then the fight started........
Date: Sun=2C 27 Sep 2009 19:20:07 +0000
=20
=20
=20

My wife sat down on the settee next to me as I was flipping channels. She

asked=2C 'What's on TV?'

I said=2C 'Dust.'

And then the fight started...
******************************************
My wife and I are watching "Who Wants To Be A Millionaire" while we were

in bed. I turned to her and said=2C "Do you want to have sex?"

"No=2C" she answered.

I then said=2C "Is that your final answer?"

She didn't even look at me this time=2C simply saying=2C "Yes."

So I said=2C "Then I'd like to phone a friend."

Does anyone know why this happens and how to correct it? Four emails had this code in them, all but one were sent using a hotmail address. I have not changed anything in my Eudora mail program so I don't think that is an issue.
I'd appreciate any answers I can find. Thanks!

I am using:
Windows XP
Eudora Email Program
 

Read other answers
RELEVANCY SCORE 73.6

As far as I've seen this is only happening with alert emails from a client's surveillance system - Gmail hides the entire body of the email except for one line, unless I tell it to "Show original".

Here's what the email looks like normally (with sensitive info redacted):
Code:
Health Monitor [10.0.0.141]
6:45 PM (2 hours ago)

to dvralerts
--_1_._VIGIL_DIGITAL_VIDEO_RECORD_BOUNDARY_--
And here's what the full thing looks like with "Show original":
Code:
Delivered-To: [email protected]
Received: by 10.--.---.-- with SMTP id p42csp2082862lfg;
Fri, 3 Apr 2015 15:45:56 -0700 (PDT)
X-Received: by 10.--.--.-- with SMTP id vr8mr7625338pbc.96.1428101154984;
Fri, 03 Apr 2015 15:45:54 -0700 (PDT)
Return-Path: <[email protected]>
Received: from mail.-------------------.com (mail.---------------------.com. [72.--.-.---])
by mx.google.com with ESMTPS id bo16si9188799pdb.32.2015.04.03.15.45.53
for <[email protected]>
(version=TLSv1 cipher=ECDHE-RSA-AES128-SHA bits=128/128);
Fri, 03 Apr 2015 15:45:54 -0700 (PDT)
Received-SPF: none (google.com: [email protected] does not designate permitted sender hosts) client-ip=72.--.--.---;
Authentication-Results: mx.google.com;
spf=none (google.com: [email protected] does not designate permitted sender hosts) [email protected]
Received: from VCM (10.--.---.--) by EMAIL.--... Read more

A:Gmail not displaying body of email

I had this same problem
I assume your browser is updated to the latest version ? When I had mine (I got a new laptop shortly after so this is only a temp fix btw), I reloaded gmail in html format. Not ideal, I know, but at least you can read them :/
 

Read other 1 answers
RELEVANCY SCORE 73.6

OE will go into the account, download messages, when you click on the message it just gives you an hourglass and you can never read the message, but you can see who it is from. I tried deleting OE, reinstalling IE. It's on Win2K Pro, I even reinstalled the OS. What can I do? Why does this problem exist even with new installations and any user who logs onto the PC?

Some history:
Initially the problem was CD drives popping open whenever clicking on Internet Explorer - ran Spybot; that problem vanished, but the Outlook Express issue appeared (or could've been there with the inception of the IE issue).
 

A:OE hangs when trying to view body of email

I would say start by downloading all updates to the operating system. Do you have all the updates applied to yuor operating system?
 

Read other 2 answers
RELEVANCY SCORE 73.6

please help me in writing outlook VBA to open emails from specific sender and copy body to excel and save it under specific name with current date
 

A:vba copy email body to excel

Read other 13 answers
RELEVANCY SCORE 73.6

I want to embed a screenshot or a section of screenshot in my email message, is there a way I to make it part of main email meassage bode except from sending it as an attachment ?
Same thikng I want to do for discussion forum also. In discussion forum, there is an option "import from word", but when I do that nothing seems to happen. So any suggestio how to do this pls ?

thanks

A:How to attach screenshot in the body of email ?

as regards the picture, you should have the option "insert picture", in my windows mail, it's the last on the formatting row, past the justify text options etc.

Read other 1 answers
RELEVANCY SCORE 73.6

I have been using Netscape Communicator for years for email with no problems, but now I have one I can't figure out. About 1/3 of the emails I now receive (POP account) the body is blank!!!
I know there is info because if I use MS Outlook I can see the body just fine. I have uninstalled Netscape and then re-installed it creating a new user profile, but the problem is still present. It almost seems as if something has trashed something else on my computer. Any help would be greatly appreciated. I do not want to switch to Outlook as the solution.

Thanks,
Teri
 

A:Body of email is blank in Netscape 4.78

Read other 9 answers
RELEVANCY SCORE 73.6

After working fine for four months in Win7 Ultimate, W.L.M. now displays the bodies of emails as attachments when I first open them. The next time I open them, or after a relaunch of W.L.M., they will probably show normally. How to fix ?

Read other answers
RELEVANCY SCORE 73.6

Does anyone know a way to stop attachments appearing in the message body with windows mail. This did not happen with outlook and can be a real pain in the **** when there are a lot of pictures attached as I often get.
I have searched every relevant forum I can find and not found an answer to this one.
Don't suggest windows live mail, I tried this but it sets up mail boxes for every account and with 4 accounts on this machine that gets a bit heavy.
 

A:Solved: Attachments in email body

Other than the setting in Options/Security Tab, "block external images and other content in html messages"
and the Read Tab "read all messages in plain text"

No.

Alternative
http://www.eudora.com/
 

Read other 3 answers
RELEVANCY SCORE 73.6

Not sure where to begin on this one.

A clients outgoing emails have started ditching the body text before arriving at the recipient end. Everything else arrives, attachments etc.


They use Outlook 2003 on Win 7. The problem happens rarely but enough to make it embarrassing and it can apparently happen with any recipient.

I could start troubleshooting but they are heavy users of email and pretty much anything I do will cause chaos.
I did however try switching off html and that seems to have helped... but why???

Many thanks in advance!

A:Email body mysteriously disappearing!

The culprit might be any application or plugin that "filters" their mail, probably an antivirus. There are known problems with AVG producing blank email bodies for example, it also happens with NOD32 and probably others. Keep in mind this could be on both ends.

More info :
Email functionality issues with ESET Smart Security: Solution checklist - ESET Knowledgebase
AVG | AVG Support and Discussion Forums

Read other 2 answers
RELEVANCY SCORE 73.6

I have attached a two page scanned document to an Microsoft Outlook email. However, it will not let me type my message in the body of the email. What is up with this? It has just started happening, and also, when the page has been scanned and trying to open up Outlook, it takes forever......any suggestions?

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, 32 bit
Processor: Intel(R) Pentium(R) 4 CPU 3.00GHz, x86 Family 15 Model 4 Stepping 3
Processor Count: 1
RAM: 2046 Mb
Graphics Card: RADEON X300 Series, 128 Mb
Hard Drives: C: Total - 97331 MB, Free - 1058 MB; D: Total - 152625 MB, Free - 52584 MB;
Motherboard: Dell Inc., 0U7077
Antivirus: Norton 360, Updated: Yes, On-Demand Scanner: Enabled
 

A:Cannot type in body of Outlook email

Maybe related to your other thread. I will have both merged and await for your response.
 

Read other 1 answers
RELEVANCY SCORE 73.6

Hello,
I'm looking to pull some data from active directory then email it to myself using Powershell. I only have been wrapping the text and it looks pretty ugly. Can anyone tell me how I can do a carriage return in an email body? Also, is there any good documentation
on formatting email bodies so they look better?
Thanks,
Scott

PS - I can't select a good forum for this, so hopefully it gets to the scripting guys.

Read other answers
RELEVANCY SCORE 73.6

After working fine for four months in Win7 Ultimate, W.L.M. now displays the bodies of emails as attachments when I first open them. The next time I open them, or after a relaunch of W.L.M., they will probably show normally. How to fix ?

A:email body shown as attachment

Could you Screenshots and Files - Upload and Post in Seven Forums

Read other 9 answers
RELEVANCY SCORE 73.2

Hi, I need an excel Macro that will copy the rows (including the header) and paste into a new Workbook and then attach the workbook to Outlook email to send. It will need to add a message in the body of the email and add the email addresses. I have included a sample workbook to review.
Thank you for you help.
 

A:Solved: Copy rows and header into new workbook and email

Read other 16 answers
RELEVANCY SCORE 72.8

okay, see if this has ever happened to anyone else. I have outlook express 6. I can create new mail messages, I can type in the "to" box and the "subject" box but when I go down to type the body of my letter... I can't type anything. I can't tab down to the body box, I can't click on the white space and get a cursor. ?!? Any suggestions?
 

A:Outlook Express 6 cannot type in body of email

Read other 11 answers
RELEVANCY SCORE 72.8

Hey people, After weeks of trying to figure out on my own how to put a pic in the body of my Msn email message and failing miserably I have come to the ex-perts(you people) to HELP ME! Please and Thanks!
 

A:Insert pics into body of MSN email message

When I got Verizon DSL, it came with free MSN Premium and when I installed MSN it also came with Microsoft Picture It! Express 9 and Library 9. So when I write an email and click on 'Share Photos' that's what MSN uses to insert pictures into the body of the email.

What happens when you do 'Share Photos'? Maybe you need to install Microsoft Picture It!.
 

Read other 1 answers
RELEVANCY SCORE 72.8

Hello,

Searched everywhere so I hope someone here can help.

I use WLM as an email client only to download my Yahoo emails.

I recently converted some 2000 old AOL emails into .eml format.

The problem is that when I import these into WLM by any means, some (about 20%) have blank email bodies.

Body is blank if
If I bring it into WLM via import, drag and drop, exporting from Windows Mail and importing into WLM the body is blank both in the reading pane and if opened from within WLM (but it can be viewed in the message source)

but Body is visible if
1) I open the email by double clicking on the .eml file, the body is there.
2) If I import the imail into Windows Mail (via import, drag and drop or copying into Windows Mail folder (User\username\Appdata\Local\Microsoft\Windows Mail\Local Folder\Inbox), the body is there.
3) If copy the file into WLM User\username\Appdata\Local\Microsoft\Windows Live Mail\Yahoo\Inbox, the body is there - BUT the From and To are both the Sender with inverted commas around and if I export and re-import the body is gone - so I'd have the problem again with any new computer

So the email body exists but can't be seen in WLM! Can anyone shed light on why the body is invisible inside WLM and how I can get it to show?

By the way, the invisible emails I've checked have Content-Type: multipart/mixed or multipart/alternative. Could this be a clue? But recent multipart not-imported emails show up fine....

PS I also have a problem with WLM showi... Read more

Read other answers
RELEVANCY SCORE 72.8

Running VISTA Home, Office 2007 Cannot see body of email of some email messages unless I click reply, options, change to view HTML, change page color to a dark color. Have no stationery set up, have disabled CA antivirus email scanning, modified registry HKEY_current_user\software\Microsoft\Office\12.0\Outlook\Options\Mail DisableEncryptedMessagePreview REG_DWORD 0x00000001(1) per help suggestion I have also changed the email options from HTML to plain text and back again.

No solutions have worked thus far. Can anyone help? Thanks in advance.

 

A:Outlook 2007 blank email body

Is the text colour white?
 

Read other 2 answers
RELEVANCY SCORE 72.8

I can't see any of the content of my emails any longer!
The READING PANEL is set OK but all I can view is the is the message header/to/from/subject etc.
When I double click or open the email still nothing!!
Outlook has been working fine so far but this has just "suddenly" happpened.
This is the same for all folders i.e. sent/outbox/deleted etc.
 

Read other answers
RELEVANCY SCORE 72.8

In hotmail, when I try to reply to an email or forward an email, the full header is in the email body. I've tried to delete the full header but then the part of the email I want to send doesn't show. Any suggestions? Thanks.
 

A:HIding full header in email body

I only get the short heading (Date, From, To, Subject), so you must have something set to view the full header.

No matter, I can't understand why you can't delete or edit just a portion of the included message and header.
 

Read other 2 answers
RELEVANCY SCORE 72.8

Hi all,

I need to automatically forward an email onto another account (using a rule), however, i need this to strip out the body of the email and only leave the subject and the attachment.

Im guessing i need to do this in VBA as a script on the rule, however, Ive tried a few (basic) options but cant master anything that remotly works.

Are you able to assist?

Thanks
 

Read other answers
RELEVANCY SCORE 72.8

Hello everybody!!!

I have a client that has a windows 2000 Pro Laptop. He uses worldclient (V 9.0.4) as his email address. When he sends me an email it has a subject. It does not however have a body. Even though he types a body in. It's a computer specific problem. All other PC's he uses are able to be sent with the body of the email.

Any ideas?
 

A:Solved: No text in body when sending email

Read other 11 answers
RELEVANCY SCORE 72.8

I can not see the body of mail in yahoo mail using firefox 3.0.5 here is my log file using
hijackthis



Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 1005 AM, on 12/24/2008
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)
Boot mode: Normal

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\system32\spoolsv.exe
C:\Program Files\CA\SharedComponents\iTechnology\igateway.exe
C:\Program Files\CA\eTrustITM\InoRpc.exe
C:\Program Files\CA\eTrustITM\InoRT.exe
C:\Program Files\CA\eTrustITM\InoTask.exe
C:\Program Files\CA\SharedComponents\PPRealtime\bin\ITMRTSVC.exe
C:\Program Files\Common Files\Microsoft Shared\VS7DEBUG\MDM.EXE
C:\Program Files\HP OpenView\Discovery Agent\bin32\discagnt.exe
C:\Program Files\Hewlett-Packard\CM\Agent\radexecd.exe
C:\Program Files\Hewlett-Packard\CM\Agent\radsched.exe
C:\Program Files\Hewlett-Packard\CM\Agent\Radstgms.exe
C:\Program Files\Common Files\ICWM\Printer\RDIConverterService.exe
C:\Program Files\Hewlett-Packard\CM\ManagementAgent\nvdkit.exe
C:\Program Files\Novell\ZENworks\Asset Management\bin\CClientSvc.exe
C:\Program Files\Novell\ZENworks\Asset Management\bin\CClient.exe
C:\Program Files\Novell\ZENworks\Asset Management\bin\T... Read more

Read other answers
RELEVANCY SCORE 72.8

I have been using Windows Mail for about 6 months with no problem, then suddenly the body of my emails has disappeared. When I open Mail with the preview pane the title detail in the top right pane looks normal, however the detail in the bottom right pane says "Message cannot be found
The contents of the message cannot be found
Windows Mail"

Is it possible to recover this information

Any suggestions gratefully received

Headley54
 

A:Body of Email missing in Windows Mail

Read other 7 answers
RELEVANCY SCORE 72.8

Whenever I receive e-mail with photos in the body of the e-mail (not attached) I cannot select them as "save as" . I receive the following message

"The system cannot find the file specified"

Using winXP SP2, IE 7 and Outlook Express 6.

Any help appreciated

Thanks.

Phil B

Read other answers
RELEVANCY SCORE 72.8

Hi,
Thanks i had a look at that and got it working sort of
its all working but its not aligned i will add a pic of what i mean.
The top is what i get from the code and the bottom one is what is should look like but it doesnt
if you cant see the pic the link is http://twitpic.com/9xqq8h
and here is the code

Thanks in advanced

Code:
Private Sub CommandButton1_Click() ' Don't forget to copy the function RangetoHTML in the module. ' Working in Office 2000-2010 Dim rng As Range Dim OutApp As Object Dim OutMail As Object With Application .EnableEvents = False .ScreenUpdating = False End With Set rng = Nothing Set rng = ActiveSheet.UsedRange 'You can also use a sheet name 'Set rng = Sheets("YourSheet").UsedRange Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = "[email protected]" .CC = "" .BCC = "" .Subject = "This is the Subject line" .HTMLBody = RangetoHTML(rng) .Send 'or use .Display End With On Error GoTo 0 With Application .EnableEvents = True .ScreenUpdating = True End With Set OutMail = Nothing Set OutApp = Nothing End Sub Function RangetoHTML(rng As Range) Dim fso As Object Dim ts As Object Dim TempFile As String Dim TempWB As Workbook TempFil... Read more

A:Allign excel code in email body?

Wel your code is unreadable.
But the alignment is a know issue.

You will have to try it by trial and error.

You van include a tab Chr(9) in your text to create tab stops but the probelm is that spaces will sthow alignmnets off.

I suggest you first pass the variables to a String variable with the layout as you would like to have it.
There is no right of Left alignment, all is left so values are not exactly in nice table form.
Before 'mailing' you can display it in a msgbox to see what it looks like (if it's not too large)

If you need help .... holler
 

Read other 3 answers
RELEVANCY SCORE 72.8

I am using "click to conver" program that converts Word coucments to HTML, and to send resulting page in body of email, I double click on the icon that would go into Outlook Express email body. But the recipient would get the email with text separated from the graphic portion. The HTML after conversion is in a folder and I click on the file "body" to get the msg to Outlook.
How do I resolve the issue? Also I notice that the graphics in the reciviing end showed up less sharp.
Any suggestions?
 

Read other answers
RELEVANCY SCORE 72.8

Hi, Any ideas on aol email, when opening a message, full message is fine to read, but when trying to reopen it, from old or recently deleted mail, the body of the message flashes once then is blank? thanks..
 

A:email message only allows opening body once then blank

Try using a different browser e.g if you are using chrome to check your email, use firefox and see if it occurs. Also clear your browser history
 

Read other 1 answers