Can anyone please help me how I can attach the files to outlook from userprofile directory.

I have to place the workbook into several machines and when a user click the send button , file is sent, please advise how can i make this work ?

Like i have a file in C:\users\XXXX\

if i use .Attachments.Add "%userprofile\filename" i get an error message the file is not found, please check the path of the file.

Please help/