attachments

Hello Everyone, i am trying to send emails to recipients with attachments but one recipient has multiple records and will have multiple attachments and i want macro to send just one mail consolidating all the rows and attachments. So far, the macro is able to send single email for every row. i...

Is it possible to add attachments to the forum or emails?

Hi, I am trying to send multiple attachments on an email. I am using the following code to send a single attachment however I would like to send all the attachments located in Column C on a sheet named "ITEM INQUIRY LIST" With OutMail .To = Range("P8").Value .CC =...

Basically I am trying to see if this is even possible. Taking an email and dragging it over some userform object such that when the user lets go it captures information from the email such as a unique ID of some sort and the attachments ( I am going to extract these and save in another...

Hi all, I have the below vba code from www.rondebruin.nl. However I would like only to have the FileCell.Value to be the filename, and have have the File Path and File Extension hard coded into the VBA as this will never change. Is there a way to do this? Thanks for your help, here is the...

Good Morning. I have created an example excel file to post specific questions but I do not have permission to upload any attachments. Can anyone tell me how to upload an attachment or gain authority to do so? Thank you.

Hello, not sure how to best title this, but I have a sheet from which I loop through each row and create an email for each row. Attachments are based on the Division name. Currently, it creates an email for every row, so if one person under Name has, say 8 divisions, they will receive 8...

The .Attachments.Count variable seems to include the embedded attachments in an email, such as images in the HTMLBody. Is there a way to only include actual attachments? Any help would be greatly appreciated!

Hi guys, I am trying to send an email automatically from excel 2013 using VBA, the email is successful, however, I am having trouble getting it to attach a document from a referenced cell. I would like it to attach the document that is linked into cell B9. The following code is what I have...

Hi All, Some help please. I'm trying to write vba code that runs on new emails that are already in a shared mail box or arrive at that same shared mailbox. The emails will have a specific subject such as "Output for PS2 model" in the subject line with a crucial difference being that part of...

I want to create a script to save the all attachments in current folder. and renaming with below Folio and Guia. Folio....... 12345 Emisor.... XXXJMXKXJXUMX RFC........ UDIXKXDYWJ Fecha..... 2017-09-21T15:33:58. Guia..... ME088265. Result should be 12345_ME088265.

I have some code that opens eml files and extracts the attachments. This works fine, but when I run the code from more than 1 desktop/server, I get an error msg. This is because they all try to use the same pst file that gets created on my network by outlook. I am working in a citrix...

Hello guys, I have a formula =INDEX(Data!A:A,MATCH(EC!F85,Data!B:B,0)) on my worksheet. I know I can copy and paste the formula all the way down the workbook but I am trying to write the formula in another cell; once I do that the formula stays in a text state instead of going to #N/A. Anyone...

Hello, I have a database that stores attachments (not too many - 150 total). I am not familiar with VBA code - I only know enough to be dangerous. I've heard there is a way to export all my 150 .PDF attachment to a directory on my C:/ drive. My database name: Property Information Database...

Hi, I am struggling with creating a macro, which could be used in Outlook. Basically, I would like a macro to search through Inbox, Sent emails and all sub folders in order to search for attachments. In case there are some emails with attachments added, macro will move these emails to specific...

Hello. I got the bulk of what I want done, but I can't quite get it there. The code I have works (from my research is called) Level 2 in outlook. Example: email@email.com/Inbox/Level 2. And this is great but what I really need it to do is have it work at Level 3 email@email.com/Inbox/Level...

Hey guys, Currently I have a code which can attach the current worksheet to an email as a pdf. However now I would like it to also attach the links which are present to the same email. Can anyone give me some help on this one? Or is it even possible. Please help

Hi Everyone I have a code that works pretty sweet except it attachs multiple attachment to one email. i would like it to attach each new file to a new email and send via range below. Can anyone help?? Many Thanks Pete Sub EmailTechProgress() Dim Source As Range Dim Dest As Workbook...

I would like to ask you if you could help me with the following. I want a rule in my Outlook to search the email's attachement for a specific word/words and in case it finds the word/words, it will move the email to a specific folder. As far as I know this is possible only using the VBA because...

I run this macro from a file that I have stored in dropbox. It creates 40+ emails and works flawlessly at my office, but each time I have run it from my laptop it creates the emails, but the emails are stuck in my outbox until I open them up, individually, and click on the send button. Both...