Attach an excel file automatically to email with VBA

[audrey]

Hello,

i was wondering if the following can be simplified using VBA ?

Action
I have two tabs in my excel spreadsheet. Tab1 and Tab2.
In Tab2, Cell A1, I type "USA"

VBA
The VBA should then filter only "USA" in Column C in Tab1
Remove the other rows in Tab1 which is not "USA"
Attach the Tab1 to Outlook as "xlsx"
with an email body text "Please see attached"
While doing it, I also do not want to lose the data in Tab1 ?


Thank you very much already!
Aude

 

[healey21]

Yes that should work as long as it resets the data to remove the filter which my code does do, but the condition must exist.

As to the formatting of the Body try this.

.htmlBody = "!BODY style=font-size:11pt;font-family:Calibri?Good Morning; !p?!p?Paragraph 1!/p?!p?Paragraph 2!/p?"

Again change each ! to a <
And change each ? to a >

As far as the signature goes you would need to know where the signature is being stored within your PC (Not just in outlook), so perhaps use the paragraph breaks and add something into the email.

 

[audrey]

thanks again, I resolved the other issues, but this one still remains

hi, when I press the <acronym title="visual basic for applications">VBA</acronym> button twice. I also get a debug error

Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Copy

 

[healey21]

Is there data against the criteria?

 

[audrey]

no it s a dropdown menu, all the data in cell A1 are within the criteria