!!Macro to attach pdf and reference excel!!

  • Thread starter Thread starter Marlene.Sawhney
  • Start date Start date
M

Marlene.Sawhney

Hi Boys and Girls,

I need a bit of help with some macros. I am trying to create a macro
that would automatically attach an pdf file to an email. Easy right?
Well, the thing is that based on the receipient the file that is
attached will change.

So, when I attach the file it needs to reference a paticular cell and
the path will indicate which file it should attach.

If .attachments.add isn't he right approach, what would be?

I have outlook 2000 and have the following macro already....any help
would be awesome...THANK YOU!

With olMyEmail
.To = ActiveCell.Text
.CC = ActiveCell.Offset(0, 1).Text
.Subject = ActiveCell.Offset(0, 2).Text
.Body = ActiveCell.Offset(0, 3).Text
.Attachments.Add -----> NEED HELP HERE TO LOCATE FILE IN EXCEL CELL

.Save
End With
 
.Attachments.Add Range("B9").Value

perhaps.

or
.Attachments.Add ActiveCell.offset(0,4).Value
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel macro to attach files in Outlook 2000 1
Formatting with Macros 3
Help! trying to send emails through excel 2
Attaching more than one file to an email with VBA 2
Excel Macro to Copy Word Text into an Email 6
Email to include a saved signature from outlook. 1
exporting to Excel without overwriting the macros 4
A Macro for Multiple Sheets that Reference one Summary Page 1

Back
Top